Estimate Calculation Effects on Cube Size

Given the current number of blocks in an Essbase cube, you can issue the MaxL statement query database … get estimated size to estimate the number of blocks that a CALC ALL calculation will produce.

To estimate the cube size resulting from a calculation, using interactive mode:

Load data, issue a CALC ALL command, and note the average block size.

Start the MaxL client or shell, log on to Essbase, and start an application and cube. For example:

 
login username password;
alter system load application appname;
alter application appname load database dbname;

Providing the application and database (cube) name, enter the following MaxL query database statement, and note the value that is returned for the number of blocks:
```
query database appname.dbname get estimated size;
```
Multiply the number of blocks by the average size of the blocks in the cube.

Results are accurate to ±10%.

Be aware of the following conditions when you query Essbase for an estimate of the full size of the cube:

You must perform this query after a CALC ALL. Any other calculation will not produce accurate results.
You can obtain accurate results with formulas only if they are on sparse dimensions.
If you need to estimate partitions, you must query Essbase for a cube size estimate on every partition and add the results. If you query for the size of only the source cube, the estimate includes only the data on the source cube server.