Managing Databases in Modeler

The Modeler allows you to add new databases (by creating or uploading them) and manage existing ones.

Adding a new database

You can add a new database to the server by creating it directly in the Modeler.

There are several start buttons to create a new database.

One button is on Jedox start screen:

And further buttons are in the Modeler:

Then the New Database window is displayed, prompting you to give your database a name. Use a name that follows the naming conventions in Jedox.

Click Ok. The database is added to the server, together with attribute dimensions and attribute, right, and system cubes.

Uploading a database

  1. Click in Modeler (see screenshot above) and select Upload database. A dialog is displayed, prompting you to give your database a name, a password (optional), and to select the database file you want to upload.
  2. Select the location of the file: the local file system, Designer, or the server file system. Click Select. The database is added to the server.

Uploading from the local/server file system

If you want to upload a database from the local or server file system, make sure the file format is .zip (case-sensitive). You can either give the file path or browse your local system for it.

Uploading from Report Designer

The Upload Database window allows you to navigate the folder groups in the Report Designer and select database WinZip files for upload.

It is also possible to create a database using Data-Driven Modeling. The uploaded database can be viewed and managed in the Modeler.

Managing existing databases and their objects

This area lists the existing databases of the connected Jedox In-Memory Database Server. You can expand/collapse each item to display the following:

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

After selecting an item, 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.

Deleting a database

You can delete a database using the dots icon in the upper-right corner of a database card in the Modeler:

Or you can delete a database by right-clicking it in the hierarchical structure and selecting Delete...

Both commands start the following confirmation dialog:

Click Ok. The database is deleted from the server.

Important: Deleting a database from the server cannot be reverted.

Rights for downloading and restoring databases

Jedox uses rights objects for granting access for general functionality to user roles. For more information, see Rights Objects in Jedox and Backup in Jedox Cloud.

Updated January 26, 2023