Consider making the following changes to members of sparse dimensions:
Tag some upper-level members of sparse dimensions that have six or fewer children as Dynamic Calc or Dynamic Calc and Store.
Tag sparse-dimension members with complex formulas as Dynamic Calc or Dynamic Calc and Store.
A complex formula requires Essbase to perform an expensive calculation. For example, any formula that contains a financial function is a complex formula. See Using Complex Formulas.
Tag upper-level members in a dimension that you frequently restructure as Dynamic Calc or Dynamic Calc and Store.
Do not tag upper-level, sparse-dimension members that have 20 or more descendants as Dynamic Calc or Dynamic Calc and Store.
See Choosing Between Dynamic Calc and Dynamic Calc and Store.