You can use the Create Blocks action to make sure that blocks are created in the database for sparse member combinations in a specified slice of data. Since there is a potential for a large increase in the database size when creating blocks, be careful when adding this action to your business rule. To help you get an idea of the size, the system displays a calculation of the block size and maximum possible blocks that would exist for the specified data slice after the business rule is launched. Since some blocks may exist in the database, this calculation does not represent the exact amount of the increase. For additional information on this action, see the Essbase Technical Reference.
To add a Create Blocks component to your business rule:
If it is not open, open the graphical business rule to which you want to add a Create Blocks action.
If the BR Language tab is not selected, select it in the bottom of the left frame of the Analytic Administration Services window.
Expand the Actions folder and double-click the Create Blocks action, or drag it to the desired location in the business rule on the Graphical tab.
The Create Blocks action is added to the business rule and the Overview tab is displayed.
For each dimension in the list that you want to include, enter a value in the Selected Values text box or click the magnifying glass icon to select the members and variables. (Only sparse dimensions are available for selection.) For more information on member selection, see Selecting Members.
Click Update to calculate the potential increase in database size.
If you make a change to the member values to be included, repeat this procedure to view the change in database storage size.