What are the two possible effects on the database when the data storage property of a parent member in the sparse Entity dimension is set to Dynamic Calc?

What are the two possible effects on the database when the data storage property of a parent
member in the sparse Entity dimension is set to Dynamic Calc?

What are the two possible effects on the database when the data storage property of a parent
member in the sparse Entity dimension is set to Dynamic Calc?

A.
Essbase data block size decrease.

B.
The member is not available for process management.

C.
Retrieval performance could be slower when referencing the parent entity member.

D.
Data cannot be input to the parent in target versions.

Explanation:
Dynamic Calc members in a block storage outline that Essbase calculates only at
retrieval time. Essbase discards calculated values after completing the retrieval request.



Leave a Reply 4

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


Claudio

Claudio

My friend, the correct answers are “C” and “D”.

A) – The datablock are composed by Dense Dimensions.

Regards.

Claudio C.

Raju

Raju

Even I feel the correct answer is “C” and “D”

Ibraam

Ibraam

C & D is the correct Answer
There is no effect on Block Size by sparse dimensions 😀