Why is the Create Blocks function in calc scripts and Business Rules important in Planning?

Why is the Create Blocks function in calc scripts and Business Rules important in Planning?

Why is the Create Blocks function in calc scripts and Business Rules important in Planning?

A.
Data may not exist for the combination of dense members so you have to create the block
before calculating the data value for the block.

B.
Data may not exist for the combination of sparse members so you have to create the block
before calculating the data value for the block.

C.
Data may not exist for the combination of dense members so you have to create the block
before block loading data to the block.

D.
Data may not exist for the combination of sparse members so you have to create the block
before loading data value to the block.

Explanation:
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.
Note: You can choose from four possible actions to include in a graphical business rule:
Aggregate
Data, Copy Data, Clear Data, and Create Blocks.
* Create Blocks—Use to specify a data slice to ensure that blocks are created for all sparse

member combinations in that slice.
* Aggregate Data—Use to calculate your database by specifying which dimensions to calculate
and what calculation options you want to use during the aggregation.
* Copy Data—Use to copy data from one part of your database to another. You select the
source data to copy and specify the target or destination value.
* Clear Data—Use to define a subset of data that will be cleared from the database before a
new value is added. You can choose to clear cells or to clear blocks of data.
Reference: Hyperion Business Rules, Administrative Guide, Release 9.3.1, Adding a Create
Blocks Actio



Leave a Reply 3

Your email address will not be published. Required fields are marked *


Claudio

Claudio

The correct one here is “B” because on the option “D” you are loading data into the cube so the blocks will be created anyway, but when you perform a calculation is neccesary to use the Create Blocks function.
Regards
Claudio C.