Calculate Memory Used by Olap

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. 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s