Open the Modeler and select a database, then click on Cubes to expand the list of cubes in the database. To create a new cube, either right-click on Cubes or click on the icon, as indicated in the screenshot below:
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.
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.