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 1) command, with the exception of "system.database" 2). |
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.
Updated January 29, 2024