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 userinterface of the Modeler has changed.

You can start the Modeler with the corresponding panel of Jedox Web or with the corresponding button in 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. Button to connect or disconnect with the selected server: in the screenshot above, “localhost” is connected.
  3. Button to create a new database.
  4. Existing databases and their objects.
  5. Details of a selected database object.

Existing databases and their objects

 

In this area are listed the existing databases of the connected OLAP 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.

 

With right-click on a single object, you receive corresponding context menu commands.

Details of a selected database object

Depending of the selected object, you receive the following details:

  • Database: tabs Database Properties, Security and Internationalization.
  • Dimensions: List of dimensions with info about their sizes, in which cubes they are used and on how many elements are rights. In the corresponding KB article, you will find the info about the creation of a new dimension.
  • A single dimension: tabs Elements, Dimension Properties and Internationalization
  • Cubes: List of cubes with info about used dimensions, filled cells, rules and rights. In the corresponding KB article, you will find the info about the creation of a new cube.
  • A single data cube: tabs Cube Properties, Rules, Security and Internationalization.
  • A single attribute cube: tabs Cube Properties and Rules.

Tab Database Properties
Here you receive the areas Name & Description, Information and Advanced. In the area Advanced you can make settings for the visibility of elements, for the database default access, for the database initial access und for the database default language.

Tab Security
In the case that you have yourself the corresponding rights you can set here group rights for the database.

Tab Internationalization
Here you can add languages which should be supported and you can translate the name(s). In the corresponding KB article, you will find more info about the internationalization of databases.

Tab Elements
Here are displayed the existing elements of the selected dimension. In the corresponding KB article, you will find more info about the creation and the handling of elements.

Tab Dimension Properties
Here you receive the areas Name & Description, Attributes, Information, Settings (Default Elements), Subsets and Advanced. In the area Advanced you can assign a dimension template for the selected dimension.

Tab Rules
Here you will find the commands for rules, e.g. Add, Edit, Delete, Import, Export.

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.

Above the context menu commands of the cube Sales in the database “Demo”.

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

Add business logics…

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 database script…

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

Create script…

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. Available on the elements „Dimensions“ and „Cubes“.

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, 7 votes)
Loading...