Managing Cubes in Modeler

image_pdfimage_print

Cubes can be created and deleted in the Modeler.

To create a new cube, start the Modeler. Then do the following steps:

  1. Select Cubes in the hierarchy structure of a database or click Open cubes of a database card:
  2. You receive the expanded cubes of the selected database and
    you can select Add cube or New… by right-clicking Cubes:
  3. The New Cube dialog appears; there you can enter a name and a description of the cube.
    You can use a predefined template or, if you want to define a custom cube, you have to select the dimensions you want:
  4. Click OK to finish.

If a dimension doesn’t exist, creating a cube using a template creates it.

You can add your own template scripts that you can later use in the Modeler when you create cubes. Go to tomcat/webapps/rpc/WEB-INF/classes/rpc.properties. Give the db_tmpl.dir= parameter the path to the directory containing custom scripts as a value. For example, in Windows you would add the following parameter to the directory: db_tmpl.dir=C:/Program Files (x86)/Jedox/Jedox Suite/tomcat/custom/templates. Make sure it is an absolute path (on Linux it must be absolute within the chroot). Within this directory, place the script file in the cube subdirectory.

Important: If you have custom template scripts in the old location (\httpd\app\etc\tmpl), you must move them to the custom location above and set the configuration key in rpc.properties.

You must restart the Tomcat service after adding a new key value or changing an existing one.

Scripts files added in the directory need to conform to the naming scheme <number>_<templatename>.jds.

Requirements

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: 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 details

You can view details about every cube in the database in table format when you select Cubes in the hierarchy structure of a database:

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.

 

Deleting a cube

You can delete a cube by:

  1. Selecting it and using the button Delete cube
    (for the selection, do not click on any blue text, otherwise you will start the link to open the cube!).
  2. Right-clicking it in the hierarchy structure and selecting the command Delete…

Important: deleting a cube from the server cannot be reverted.


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

image_pdfimage_print