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:
A:Usage of dynamic calc in sparse dimensionincludes benefits such asshorter aggregations smaller database
size.
C:Consider the number of members underneath a sparse parent. It’s generally good practice to have few (up to
20) members under dynamic sparse parents if your block size is not massively huge. This number might
increase if your block size is tiny.