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
Correct Answer: ABC
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.
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.
|
Download Printable PDF. VALID exam to help you PASS. |
 |