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.