Consider making the following changes to members of dense dimensions:
Tag upper-level members of dense dimensions as Dynamic Calc.
Try tagging level 0 members of dense dimensions with simple formulas as Dynamic Calc, and assess the increase in retrieval time.
Simple formulas do not require Essbase to perform an expensive calculation. Formulas containing financial functions or cross-dimensional operators (->) are complex formulas.
Do not tag members of dense dimensions as Dynamic Calc and Store.