Tracing a Rule Calculation Example (Simple)
Procedure
- Open the Trace_simple view of the
SalesCube cube.
This view contains the Price values that are derived through rules you created earlier in this section.
- Right-click the cell at the intersection of Price and Jan.
- Select Trace Calculation.
The Rules Tracer window opens.
In the Tracing Calculation pane at the top, TM1 displays the current cell definition, along with Rules icon
indicating that the cell value is derived through rules. The rule that applies to the cell
is shaded, and the Calculated value of the cell displays in the lower right corner of the
pane.In the Trace pane at the bottom, TM1 shows the evaluation of the rule that applies to the current cell. In this example, the rule
['Price']=N:DB('PriceCube',!actvsbud,!region,!model,!month); C:['Sales']\['Units']*1000;evaluates to
['Price']=PriceCube(Actual, Germany, L Series 1.8L Sedan, Jan)because the current cell is an N: location (not defined by any consolidations).
You now know that the cell SalesCube(Actual, Germany, L Series 1.8L Sedan, Price, Jan) takes its value from PriceCube(Actual, Germany, L Series 1.8L Sedan, Jan).