The increase in retrieval time when you dynamically calculate a member of a dense dimension is not significant unless the member contains a complex formula. The increase in retrieval time may be significant when you tag members of sparse dimensions as Dynamic Calc or Dynamic Calc and Store.
The following sections discuss ways you can analyze and manage the effect of Dynamic Calc members on a database.
For a list of functions that have the most significant effect on query retrieval, see Choosing Between Member Set Functions and Performance. |