Creating New Cubes


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

  1. From the Modeler and select a database.
  2. Click Cubes to expand the list of cubes in the database.
  3. Create a new cube by either right-clicking Cubes and selecting New… or click  the  icon, as indicated in the screenshot below:
  4. The New Cube dialog appears, where you can enter a name and description of the cube. You can also select from a list of templates and select dimensions for the cube.
  5. Click OK to finish.

There are two requirements for creating a cube:

  • You must have at least one available dimension in the database.
  • Each selected dimension must have at least one element.

Note: with Excel 2007 and newer versions, cubes are limited to 250 dimensions due to processing limitations of the PALO.DATA functions.

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

  • Fact Cube – a cube containing the data used by end users. These are the facts representing the regular business activities.
  • Master Data Cube – a cube containing additional information about master data, other than the dimension attributes.
  • Control Data Cube – a cube containing data for controlling the behavior of the Jedox application, such as the behavior of the reports or parameters used by rules.

These types allow the modeler to group the dimensions by category, to increase the overview of the database.

Cube Overview

You can view details about every dimension in the database in table format in the Cubes Ovreview:

Cube Shows the cube name,
Dimensions Shows the number of dimensions in the cube.
Filled cells Shows the number of filled cells.
Rules Shows the number of rules applied on the cube.
Rights Shows how many groups have non-default rights assigned for the dimension elements.