Related link: Column header in Data Driven OLAP
Data-driven modeling is an innovative process that enables users to analyze existing data earlier and faster. It was designed for Jedox Excel Add-in and implemented in Jedox Software as of Version 5.1.
Instead of creating OLAP cubes manually, data-driven modeling allows you to generate and fill a new Jedox OLAP cube from your existing data as CSV or Excel content. The Data-Driven Modeling Wizard models the data cube automatically and intelligently from existing data. Additionally, data-driven modeling creates a complete Jedox Integrator (ETL) script that can be further specified and used to populate the data cubes on a periodic basis.
Below are the requirements for the data-driven modeling procedure.
Jedox Web and Jedox Integrator must be installed and the connection from Excel Add-in to Jedox Web must work correctly. For more information, see Connecting Jedox Excel Add-in with Jedox Web.
Data-driven modeling is supported for a file size of max 128 MB. This default value is defined in the file <install_path>\httpd\php\php.ini in the lines post_max_size and upload_max_filesize. Please adjust these values in case of a bigger file.
In order to use DDM in an environment with Windows Single Sign On, please read the article “SSO Windows Configuration“.
A user requires delete rights (D) on the following rights objects: database, cube, dimension, dimension element, cell data, ste_files, ste_etl, and ste_reports.
Jedox Setup provides three examples to test Data-Driven Modeling: FiletoOLAP1.csv, FiletoOLAP1.xls and FiletoOLAP2.csv, all of which you can find in C:\Users\Public\Documents\Jedox\Jedox Suite.
Now we will demonstrate the import of the example FiletoOLAP1.csv. The data file looks like this:
After click the button “Data-Driven Modeling” you receive “Data-Driven Modeling Wizard”:
Here you select the file for the creation of new cube.
When the source file for FileToOLAP import is CSV, it needs to be selected from file tree/recent list (i.e., a saved version). The option to use “Current Workbook” is only supported for XLSX files. When you check “Show detailed settings” and click Next, you get the following dialog:
Here you can change the suggested names for project, database, and cube. Furthermore, you can select to overwrite an existing project, append data, and create a dimension “Versions”.
- 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.
The option “Create dimension ‘Versions'” creates the dimension Versions with Variance, consolidated of Actual(1), and Budget(-1). Imported data will be written in Actual.
In the case of a CSV import, the options „Encoding“, „Enclosure Character“, and “Delimiter” need to be set, so the file can be imported correctly. In case of XLSX import, the only the option is “Range”. This 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.
In case of success 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.