Data structures such as cubes, dimensions, and elements can be created and modeled in the Modeler. You can open the Modeler with the button indicated on the screenshot below (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 default.
Modeler Start screen
The Modeler Start screen shows databases as “cards” that indicate the size (in MB), numbers of dimensions and cubes, and loading speed of the database.
Hovering over a card displays buttons to open dimensions or cubes, with further actions available through the dots icon in the upper-right corner.
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 | Information displayed |
|---|---|
 Database
|
Properties: shows name and description, database information. Advanced: shows visibility with user access (Right N), access rights, and language. For more information, see Advanced Database Properties. Internationalization: here you can set the default language for the databases, as well as any additional languages. For more information, see Internationalization of Databases. Security: users with the necessary rights can view and/or assign rights to users of the database. For more information, see Access Rights for Databases. |
 Dimensions
|
List of dimensions with info about their sizes, the cubes in which they are used, and the number of elements for which the dimension has rights. |
 Specific dimension
|
Elements tab: shows the existing elements of the selected dimension. For more information, see Creation and Handling of Dimension Elements. Dimension Properties tab: shows the name and description, database information, and advanced settings. For more information, see Advanced Database Properties. |
 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. |
 Specific cube
|
Properties tab: shows name and description, dimensions, and other information, as well as Audit, Drillthrough, Undo Locks, Views, and Advanced Properties.
The Rules button at the top right toggles the All rules tab on/off: it provides information about rules associated with the cube. For more information, see Managing Rules and Business Rules Overview. |
 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. |
Note: the Modeler shows numeric properties for several database objects (e.g. count of cells, field cells per cube, etc.). To make such values more readable, formatting has been applied with thousand separators and can be localized based on the current user's locale.
Context menu commands for database objects
Right-click on a database, dimension, or cube to perform a variety of actions, which are described below.
| Action | Object(s) | Description |
|---|---|---|
| Add business logic | Cube | Business logic represents a set of features that you can add to existing cubes. They are usually comprised of one or more rule templates, and may also add features to existing dimensions. To be fully operational, you may have to extend other database content. |
| Clear cube | Cube | Opens a dialog to define the dimension(s) to be cleared from the cube. See "Clear cube..." command for details. |
| Create database script… | Database | Starts dialog to specify the script and the variables. Available on a single database. |
| Create script… | Dimensions, cubes | Starts dialog to specify the location, the script name and what should be included. See Database Scripts in Jedox for details. |
| Delete… | Databases, dimensions, cubes | 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, see Uploading and Downloading Dimensions or Cubes. | |
| Edit rules… | Activates the corresponding All 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. | |
| Schedule database backup | Creates a scheduler job to backup the selected database. | |
| Update the 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, see Uploading and Downloading Dimensions or Uploading and Downloading Cubes. Please note: after upload, files will be stored inside system folder "Integration \ Import". Please make sure you have applied access rights accordingly. |
Updated August 24, 2026