Understanding Dynamic Calculation
When you design the overall database calculation, it may be more efficient to calculate some member combinations when you retrieve their data, instead of precalculating the member combinations during a batch database calculation. Dynamically calculating some values in a database can significantly improve the performance of an overall database calculation.
In Essbase, you can define a member to have a dynamic calculation. This definition tells Essbase to calculate a data value for the member as users request it. Dynamic calculation shortens batch database calculation time, but may increase retrieval time for the dynamically calculated data values. See Reducing the Impact on Retrieval Time.
In Essbase you specify dynamic calculations on a per-member basis. See Understanding Dynamic Calc Members
Understanding Dynamic Calc Members
For a member tagged as Dynamic Calc, Essbase does not calculate its data value during a batch database calculation (for example, during a CALC ALL). Instead, Essbase calculates the data value upon retrieval (for example, when you retrieve the data into Smart View.)
Specifically, Essbase calculates a data value dynamically when you request the data value in either of two ways:
-
By retrieving the data value into Smart View
-
By running a report script that displays the data value
Essbase does not store the calculated value; it recalculates the value for each subsequent retrieval.