Data-Driven Modeling Exercise

image_pdfimage_print

Jedox comes with three sample files to test Data-Driven Modeling, all of which can be found in C:\Users\Public\Public Documents\Jedox\Jedox Suite. Two of the samples consist of comma-separated values and one is an Excel spreadsheet. In the example below, we will use the CSV file FiletoOLAP1.csv.

To begin the data import, click on Data-Driven Modeling in the Jedox Ribbon, as indicated below.

When the wizard opens, browse to the sample file location C:\Users\Public\Public Documents\Jedox\Jedox Suite and select FiletoOLAP1.csv. Check the box to show detailed settings and click Next.

The next screen provides a preview of the data:

Here you can change the suggested names for project, database, and cube. You can also overwrite an existing project, append data, and create dimension versions with variance, consolidated of Actual(1), and Budget(-1). Imported data will be written in Actual.

Note: The option to create version dimensions is enabled by default.

Notes:

  • If a Jedox Integrator (ETL) project exists, you have to check “Overwrite”; otherwise you receive a corresponding message and nothing will be created or imported.
  • If database name and cube name already exist, you have to check “Append data”, otherwise existing dimensions and elements will be deleted in the cube.

For XLSX imports, the Range option can be used to reduce the cell range that is used for the import.

Click Execute to start data import and cube creation:

After the import is done, you will receive a success message or, if there was a problem, an error message. If successful, you can check the Modeler for all creations/changes regarding your database name and cube name.

In Jedox Web – Panel Integrator, you will find your entered project name with all new modules created with the Data-Driven Modeling Wizard.

image_pdfimage_print