Rules

The Rules table contains rules. Rules apply to specific areas of a cube. The cell values of a cube are not stored in the database: they are calculated at the moment they are retrieved. Accelerators are rules that accelerate this calculation.

You can create rules in this table. To create rules in this table, you must specify this information:

Column	Description	Required
ID	To create a rule, double-click <New: ID> on the bottom of the table and specify the primary key of the rule. This is the unique identification of the rule within the OLAP data model (no special characters, max. 72 characters).	X
Order Position	Non-alphabetical element order when sorting in tables and when building a database. In tables, entries are first sorted according to their order position, then according to the ID.
Rule Type	Type of the rule. Specify 1 or 2 (1 = accelerator, 2 = rule).
Source Area	Source area of the accelerator. The entry is required, if you select Accelerator as the rule type.
Target Area	Target area to which values are written. The entry is required, if you select Rule as the rule type.
Rule	Here you specify the rule or accelerator.
Enabled	Specify Y to enable the settings.
Data Source ID	ID of the source from which the data are retrieved. Double-click a cell of this column and select a source from the Data Sources table.
Cube	Double-click a cell of this column and select a cube for the rule.
ParentRuleGroupID	The ID of the rule group to which the rule is assigned.
Name	Descriptive element name of a rule.