Which statementsaccurately describe when blocks will be created?

A calculation script is performed on a database for which Create Block on Equation is OFF.
The command SET CREATEBLOCKONEQ ON is issued immediately before an equation in
the script. Which statementsaccurately describe when blocks will be created? (Choose two)

A calculation script is performed on a database for which Create Block on Equation is OFF.
The command SET CREATEBLOCKONEQ ON is issued immediately before an equation in
the script. Which statementsaccurately describe when blocks will be created? (Choose two)

A.
Blocks will be created ONLY when the equation assigns non-constant values to members
of a sparse dimension

B.
Blocks will be created ONLY when the equation assigns constant values to members of a
sparse dimension

C.
Blocks will be created when the equation assigns either constant or non-constant values
to members of a spare dimension.

D.
No blocks will be created.

Explanation:
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.
http://download.oracle.com/docs/cd/E12032_01/doc/epm.921/html_techref/calc/set_createbl
ockoneq.htm



Leave a Reply 0

Your email address will not be published. Required fields are marked *