Solved

How do you calculate the size of the DataBlock?

Posted on 2009-07-08
3
712 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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
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.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

758 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now