Calculate Memory used by OLAP
To calculate memory, the formula is:
DimSize = (M x (61 + 4L + Sa + Sk))) + 4P + Sn
where
- M: Number of members in the dimension.
- L: Number of levels in the dimension, including the ALL level.
- Sa: Average size required to hold the member names.
- Sk: Size required to hold the member key.
- P: Number of member property settings in the dimension for all levels.
- Sp: Size required to hold the distinct member property values for all member levels.