CalculateFromStoredData

The CalculateFromStoredData parameter determines whether existing data values in closed periods (outside the focus range or selected data slice) are re-evaluated or directly read from the database during a consolidation. These settings are available:

Value Description
0 (Default) Re-evaluates formulas in closed periods. By default, on the Set Properties page, the check box for this parameter is not selected.
1 Reads values in closed periods directly from the database

Setting the value to 1 preserves existing data and formula results in closed periods.

Type: Scripting Parameter, Engine property