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:
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.