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

Answer options:

A. Copy data
B. Load data
C. Create block on Equation
D. Aggregate data

ABC

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 DataUse 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.