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