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.
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.
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit