Rules

You can create complex data calculations in IBM® Planning Analytics with business rules.

The most common calculations in Planning Analytics involve aggregating data along a dimension. These calculations are performed automatically based on your dimension hierarchy definitions. However, in many models you need to perform calculations that do not involve aggregating, such as cost allocations and exchange translations. With business rules, you can create formulas to perform these calculations.

With business rules, you can perform the following tasks:

Multiply prices by units to yield the sales amounts.
Override consolidations when necessary. For example, you can prevent a quarterly price from displaying a tally of individual monthly prices.
Use data in one cube to perform calculations in another cube, or share data between cubes. For example, you can pull sales data into a cube that contains Profit and Loss information.
Assign the same values to multiple cells.

For more information about business rules, see the TM1 Rules documentation.