Select all that apply

Name the valid ways to create blocks in an underlying Essbase database. Select all that apply

A.
Copy data

B.
Load data

C.
Create block on Equation

D.
Aggregate data

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.