Rule Extract

With this extract, business rules can be extracted from a particular cube or defined directly in Jedox Integrator.

Main Settings
Manual definition Each rule must be defined as in the OLAP database, with the rule definition, an optional comment, and an active parameter (true/false). The latter indicates whether the rule should be activated or deactivated after the load. The rule is defined in the Manual definition area, described below.
Extract from cube If this mode is selected, you can select the OLAP connection and the cube from which the rules are to be extracted must be entered. See Connection, below.
Connection This is the OLAP connection for the cube.  This field is only available if you selected Extract from cube in the Mode setting.
Query cube Select the cube from the drop-down box. The cubes shown are from the OLAP connection specified under Connection (above). This field is only available if you selected Extract from cube mode in the Mode setting.
Manual definition if you have selected Manual definition mode (see above), you can write a rule in the Rule extract. It is important to use the correct syntax used by the OLAP server. See Rule Editor for more information on rule syntax in Jedox.
Advanced Settings
Included rule types (at least one must be selected)
Regular rules Rules that are written by the user. See Business Rules Overview for more information.
Rule templates Rules that are parametrized. See Rule Templates for more information.
Generated rule instances Rule templates that have been parametrized/triggered. See note below.

Note: if an extract has been filtered for generated rule instances, then it cannot be used as the source for a rule load that uses load mode “update”. This is because update mode deletes all existing rules in the target cube. Rule instances cannot run without rules or rule templates, and so the load cannot run.


If you add a rule like this:

[‘Turnover’] = C:[‘Units’]/100.

the Jedox OLAP server will change this rule using the right syntax into:

[‘Turnover’] = C:[‘Units’] / 100.

If you use this as a source in a rule load with INSERT mode, then the rule will be added as a new rule, because it is not the same as in OLAP. Therefore, it is better to create the rule in the Rule Editor and then copy the definition with correct syntax to the Rule Extract.

Note: rule templates use the same syntax for variables as Integrator projects: ${varname}.  If a rule template and an Integrator project use a variable with the same name, the variable will be handled by the Integrator task, not the rule template. Problems can be averted by changing the Integrator variable name on a project level.