Calculation Status

If the existing data set for a POV changes, the calculation status is updated accordingly. A timestamp table is used, and servers are synchronized to ensure the calculation status is always accurate.  

To explore calculation status, build a Cube View where the View Member in the Point of View is set to CS, the columns are the time periods, and the rows are set to the desired Entity structure. For example:

These status codes indicate what action to perform:

• OK: The data for this intersection has not changed since the last calculation.

• OK, NA: Calculation not required. No data.

• OK, MC: The intersection was calculated but metadata changed due to modifications to artifacts such as Business Rules associated with this Cube, formulas and FX rates. This is a clue that if the calculation is run again, the results may not be the same.

• CA: Calculate data since an import was run or data was entered.

• TR: Translate.

• CN: Consolidate because data for a child Entity has changed.

• CA, CN: Calculate and consolidate.

• CA, TR: Calculate and translate.

• TR, CN: Translate and consolidate.

• CA, TR, CN: Calculate, translate and consolidate.