How do you calculate the size of the DataBlock?

How do you calculate the size of the DataBlock?
AJITPADHYIT operation leadAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

garycrisCommented:
In order to calcualte the size of a data block you first determine the number of cells in each block.  There is one cell for each dense dimension, stored member, combination.

So if you have a Time dim that is Dense and has the following Stored Members

Time
--Jan
--Feb
--Mar

And and Accounts dimension that is Dense with the following Stored members

Accounts
--Margin
----Sales
----COGS

You would have 16 unique combinations (4 x 4) Take note I included the root members of the dimension as they are stored members in this example.  In real world, many of my upper level members in dense dimensions would be dynamic calc or label only, meaning they are not stored and therefore would not be considered when calculating my block size.  This is a way to optimize my outline and keep my blocks smaller.
So if I have 16 cells, each cell is 8 bytes.  Therefore my block size would be 128 bytes (16 cells x 8 bytes per cell)

If I had a third dense dimension with 10 stored members then I would simply add to my calc
 4 x 4 x 10 = 160 cells x 8 bytes = 1280 bytes.

Notice how my block size gets exponentially larger as I add additional dense dimensions.  Be aware of this and choose your dense dimensions carefully.
 
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
AJITPADHYIT operation leadAuthor Commented:
thanks
0
AJITPADHYIT operation leadAuthor Commented:
thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB Reporting Tools

From novice to tech pro — start learning today.