Solved

How do you calculate the size of the DataBlock?

Posted on 2009-07-08
3
715 Views
Last Modified: 2012-05-07
How do you calculate the size of the DataBlock?
0
Comment
Question by:AJITPADHY
  • 2
3 Comments
 
LVL 5

Accepted Solution

by:
garycris earned 500 total points
ID: 24803670
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
 

Author Closing Comment

by:AJITPADHY
ID: 31600993
thanks
0
 

Author Comment

by:AJITPADHY
ID: 24825513
thanks
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question