Definition rules

Definition rules calculate values for cells in the model cube every time that the model is deployed. Definition rules are typically used to calculate volatile values. For example, definition rules calculate aggregated account values that must be re-computed every time that the value of a corresponding dimension member changes.

Although Planning Business Modeler includes several predefined definition rules, it is also possible for definition rules to be user-defined. When a definition rule is user-defined, the rule must use MdxScript implementation. When the definition rule is deployed, Planning Business Modeler translates the rule into MdxScript, and installs the translated script in the underlying cube. Rules with MdxScript implementation do not affect underlying fact tables, and no results are persisted in the model.

Note

You may not import a Definition rule set. Planning Business Modeler provides a predefined Definition rule set, and does not support importing other Definition rule sets.

The calculations of a definition rule are performed and cached every time that you query a cell set in the scope of the rule.

The following list shows the pre-defined definition rules that are included in Planning Business Modeler.

See Also

Concepts

MdxScript implementation

Other Resources

Choose a rule type