Description of Modeler

image_pdfimage_print

Data structures consist of cubes, dimensions, and elements that can be created and modeled in the Modeler. As of Jedox 7.0 the user interface of the Modeler has changed.

You can start the Modeler with the corresponding panel of Jedox Web or with the corresponding button in the Jedox Ribbon of the Excel Add-in. To start from the Excel Add-in, a connection with Jedox Web must be defined as the default.

Description of the components as indicated by the numbers in the screenshot above:

  1. List box to select a Jedox Server connection.
  2. Pulldown menu with the commands “Connect/Disconnect” (to/from the selected server), “Create New Database”, and “Upload Database”.
  3. Existing databases and their objects
  4. Details of selected database objects

Existing databases and their objects

 

In this area are listed the existing databases of the connected Jedox In-Memory Database Server. In front of the objects are buttons to expand/collapse their structures. In this way you can display the following database objects:

  • Dimensions
  • Cubes
  • Attribute cubes
  • Rights cubes
  • System cubes

After selecting one object, the corresponding details are displayed on the right of the screen.

 

By right-clicking on a single object, you can access the corresponding context menu commands.

Details of selected database objects

When you click on a database object, such as a database, dimension, or cube, the right pane of the Modeler displays information about that object:

Database object Properties displayed
  Database 

Database Properties tab: shows name and description, database information, and advanced settings. For more information, see Advanced Database Properties.

Security tab: users with the necessary rights can view and/or assign rights to users of the database. For more information, see Access Rights for Databases.

Internationalization tab: here you can set the default language for the databases, as well as any additional languages. For more information, see Internationalization of Databases.

  Dimensions

List of dimensions with info about their sizes, in which cubes they are used, and the number of elements for which the dimension has rights. For more information on these properties, see Creating New Dimensions.

 Specific dimension

Elements tab: shows the existing elements of the selected dimension. For more information, see Creation and Handling of Dimension Elements.

Dimension Properties: shows name and description, database information, and advanced settings. For more information, seAdvanced Database Properties.

Internationalization tab: shows the available language(s) for the dimension.

  Attribute dimensions

 List of attribute dimensions showing numbers of elements, cubes, and rights.

 Cubes

List of cubes showing which dimensions are used and the numbers of filled cells, rules, and rights privileges. For more information on these properties, see Creating New Cubes.

 Specific cube

Cube Properties tab: shows name and description, dimensions, and other information, as well as Audit, Drillthrough, Undo Locks, and Advanced Properties. 

Rules tab: provides information about rules associated with the cube. For more information, see Working with Business Rules.

Security tab: users with the necessary rights can view and/or assign rights to users of the database. For more information, see Access Rights for Databases.

Internationalization tab:  shows the available language(s) for the cube.

 Attribute cubes

 List of attribute cubes showing numbers of dimensions, filled cells, rules, and rights

 Rights cubes

  List of rights cubes showing numbers of dimensions, filled cells, rules, and rights

 System cubes

  List of system cubes showing numbers of dimensions, filled cells, rules, and rights

Context menu commands of single database objects

With right-click on a single element, e.g. a database, a dimension, or a cube, you receive corresponding context-menu commands.

Context menu commands for the cube Sales in the Demo database

Here the list of all context menu commands in this area in alphabetical order:

Add Business Logic

Starts dialog to add a business logic template. Available on a single cube.

Clear Cube…

Starts dialog to define the cube area in which you want to delete the values.

Create Script… (database)

Starts dialog to specify the script and the variables. Available on a single database.

Create Script… (cube)

Starts dialog to specify the location, the script name and what should be included. Available on a single dimension or a single cube.

Delete…

Asks if you really want to delete the selected element. Available on a single database, a single dimension, or a single cube.

Download…

Starts the corresponding Download Wizard. Available on a single dimension or a single cube.

Edit Rules…

Activates the corresponding Rules tab. Available on a single cube.

New…

Creates a new dimension or a new cube. 

Run Database Script…

Starts dialog to specify the script and the variables. Available on a single database.

Run Script…

Starts dialog to specify the script and the variables. Available on a single dimension or a single cube.

Update Rule Templates

Updates the rule templates of the selected database or the selected cube.

Upload file…

Starts the corresponding Upload Wizard. Available on a single dimension or a single cube.

 

 

 

image_pdfimage_print
Was this post helpful?
NoYes (+1 rating, 5 votes)
Loading...