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.