With this extract, rules can be extracted from a particular cube or defined directly in Jedox Integrator.
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.
|Connection||This is the OLAP connection for the cube. This field is only available if you selected Extract from cube mode above.|
|Query cube||Select the cube from the listbox. The cubes shown are from the OLAP connection specified under Connection. This field is only available if you selected Extract from cube mode above.|
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.
Here you have the option to filter for the following types of rules. You must select at least one.
- Regular rules (rules written by the user)
- Rule templates (rules that are parametrized)
- 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.