Rule Load


With this load, business rules can be written into a Jedox OLAP Server database.

Main settings
Data source The data source must consist of the following 4 columns: – Column 1:  Rule definition. If the Rule is inactive the definition is prefixed with “#”. – Column 2:  An optional Comment of the Rule – Column 3:  Optional External ID – Column 4:  Optional Timestamp
Target connection Connection to Jedox OLAP database
Target cube  Cube in the Jedox OLAP Server
Load mode

The following modes are available:

update: All existing rules are deleted in the target cube and all rules of source are written to it.
insert: All rules of the source that don’t exist in the target cube (based on the definition of the rule) are added to the cube.
delete: All rules of the source that exist in the target cube (based on the definition of the rule) are deleted in the cube.

This structure is analogous to the organization of the extract rule. Rules that are read with the help of extracts from a Jedox database or manually created can therefore be written directly by referencing the data source. It is also possible to build a data source that adheres to this structure for rules with the desired extracts and transforms. As rules are matched based on the definition of the rule, it is important for modes “insert” and “delete” to use exactly the same rule syntax as in the OLAP database.