Creating New Dimensions


Open the Modeler and select the Demo database, then click on Dimensions to expand the list of dimensions in the database. To create a new dimension, either right-click on Dimensions or click on the  icon, as indicated in the screenshot below:

The New Dimension dialog appears, where you can enter a name and description of the dimension. You can also select from a list of templates, which will define the elements in your new dimension.

Click OK to finish.

If you create a dimension with no template assigned, you can still assign it a type after creating it. To do this, open the dimension in the Modeler, go to Advanced and select the type from the drop-down list. The following options are available:

  • Versions – the elements of this dimension represent data sets such as Actual, Budget or Forecast. They have different origins, such as source systems or planning processes.
  • Time – the elements of this dimension represent a time unit, such as day, month, quarter or year, and aggregations thereof. Once selected, this option enables the Time Editor, which allows you to maintain the time dimensions.
  • Business – the elements of this dimension represent values broken down in hierarchies, displaying how a company organizes its business. Common business dimensions are Regions, Companies, Cost Centers, Products or Customers.
  • Accounts – the elements of this dimension represent ledger accounts, as used by accounting, or similar concepts, as reporting positions or planning items. The hierarchy in an account dimension (also known as a chart of accounts) uses factors for a meaningful aggregation. For example, the factor -1 is used in Profit = Income – Expenses. The factor 0 is used in Total Revenue = Services + Sold Products + Other Revenue + (0* Thereof Interest Revenue).
    Note: The list of accounts and its hierarchy are subject to maintenance and can vary over time to reflect changes in the business process.
  • Measures – the elements of this dimension represent different transactional data information stored in the cube. Similarly to Accounts, you can specify different meanings of measures (such as element type – numeric or string, the units of measurement (amount, units, weight, length), the display format, the aggregation behavior over time, or the calculation formulas. Unlike accounts, there are usually only a few measures and they remain fixed over time.

This option increases the overview of the database by grouping all the dimensions based on their type.