JDS (Jedox Database Script) Load

This type of load allows the execution or creation of Jedox database scripts, providing you with an effective way to control the models' structure with all its rules and objects.

There are two script action types for JDS loads: run and create. The settings for each action type are described below.

Script action "run"

This action executes an existing Jedox script.

Olap target connection The target connection of type JedoxOlap.
File source connection The source connection of type JDSFile.
Script variables Assign any variables that are initiated in the script with the variable_DECLARE command, with the exception of "system.database" .

Script action "create"

This action creates a new Jedox script.

Olap source connection The source connection of type JedoxOlap.
File target connection The target connection of type JDSFile.
Script type Select the script type, i.e., database, cube, or dimension.
Target dimension Specify the target dimension, when creating the respective script type.
Script options Choose which objects to include.

Notes:

  • 1) For the variable_DECLARE command to work properly, it must be included at the beginning of the script after the mandatory VERSION command, but before any other commands.

  • 2) If the script declares a variable named "system.database", it will never be displayed in the variable lists because it is defined by the Olap target connection.

  • The file size limit for running a Jedox Database script is 500 MB.

  • When creating a script from a database / cube with the "Include Values" option set to "true", the memory size is limited to 100 MB.

Running a load

To run the load, select Run from the toolbar, indicated in the screenshot below. The load executes using the variable values currently saved in the component.

screenshot indicated the Run button for integrator loads and jobs

screenshot indicated the Run button for loads and jobs

To run the load with different values without changing what's saved in the component, select Run with options from the dropdown next to Run. This opens a dialog listing the component's variables. Update any variable value as needed, then use the reset icon next to a field, or select Reset all, to restore its saved value. Select Run in the dialog to execute the load using those values; they apply only to that run. If the load has no variables, the dialog states that no variables are used; select Close and run the component normally instead.

To run the load with different values without changing what's saved in the component, select the arrow next to Run and choose Run with options. This opens a dialog listing the component's variables, where you can change values for this run only; the saved values are not affected.

Updated September 29, 2026