With this load, business rules can be written into a Jedox OLAP Server database.
|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|
The following modes are available:
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.