Explanation/Reference:
Explanation:
Ways to create data blocks:
1. Data Load, (B)
2. DataCopy Command, (A)
3. Sparse Dimension Consolidation,
4. Member Formulas:
4a. Assiging a constant value to a sparse member,
4b. Turning Create Block on Equation setting on and assiging a non constant value (C)
4c. Create non missing blocks
B: The moment we load data to essbase, It creates block for those combinations automatically.
C: Controls, within a calculation script, whether or not new blocks are created when a calculation formula assigns anything other than a constant to a member of a sparse dimension. SET CREATEBLOCKONEQ overrides the Create Block on Equation setting for the database.
If calculations result in a value for a sparse dimension member for which no block exists, Analytic Services creates a new block. Sometimes, the new blocks are not desired; for example, when they contain no other values. In large databases, creation and processing of unneeded blocks can increase processing time as well as the storage requirement for a database.
For the situation when new blocks would be created as a result of assigning something other than a constant to a member of a sparse dimension, Analytic Services provides the Create Blocks on Equation setting. For example, when the Create Blocks on Equation setting is ON and West is assigned a value where it did not have a value before, new blocks are created. When this setting is OFF, new blocks are not created.
Incorrect answer:
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.
D: Aggregate data. There is no such specific command or utility. It is just a general concept in the Hyperion context.