Introduction to rules

This section provides an introduction to IBM® Planning Analytics cube rules, which enable you to derive cell values through calculations.

Overview of cube rules
The most common calculation in OLAP applications involves aggregating data along a dimension. In IBM Planning Analytics, you create these calculations by using consolidations. For example, in a Month dimension, you can define a quarterly consolidation that sums January, February, and March values.
Accessing rules
You create and edit rules in the Rules Editor. The Rules Editor is basically a text editor that helps you create accurate cube references, with menu options and toolbar buttons to insert commonly used rule syntax, characters, and functions.
Using the Rules Editor window
The Rules Editor combines advanced code editing features with TM1® specific tools to help you create, manage, and verify your rules. This section provides an overview of the menus, toolbar buttons, and code editing features that you can use when working in the Rules Editor.
Components of a rule
A rule is composed of one or more calculation statements that define how values in the associated cube are calculated.
Bypassing rules
By using the STET function, you can bypass the effect of a calculation statement for specific areas of a cube.
General considerations
Here is additional information about bypassing rules.
How rules work
The following sections describe how rules work within TM1 and provide considerations you should keep in mind when you develop rules.
Memory utilization and rules
TM1 does not store rules-derived values on disk or load such values into memory when a cube is initially loaded. Instead, when you request a cube value.
Monitoring rules statistics
You can monitor rules statistics that provide insight as to how frequently individual statements within a rule execute and how long it takes to run a rule statement.

Parent topic: TM1 Rules