Creating New Dimensions

To create a new dimension, follow the steps in the example below:

  1. From the Modeler, select the Demo database.
  2. Click Dimensions to expand the list of dimensions in the database.
  3. Create a new dimension by either right-clicking Dimensions and selecting New… or by clicking the  icon, as indicated in the screenshot below:
  4. 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 define the elements in your new dimension.
  5. Click OK to finish.

Assigning Dimension Types

Assigning types to dimensions increases the overview of the database by grouping all the dimensions based on their type. If you select a template when you create a dimension, it is automatically assigned a type. If you create a dimension with no template assigned, you can still assign it a type after creating it. When you assign a type to a dimension, it does not make any changes to the dimension itself. Only if you assign the type TIME, the time editor is enabled.

To assign a type, 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.

Dimensions Overview

You can view details about every dimension in the database in table format in the Dimensions Overview:

Dimension Shows the type of the dimension.
Size Shows the number of elements and the levels of distribution.
Cubes Shows the number of cubes containing the dimension.
Rights Shows how many groups have non-default rights assigned for the dimension elements.

 


Learn more about creating dimensions in a free online course from Jedox Academy! Just enter your email address when prompted, and the video will begin playing.