What two design principles should you follow related to the dynamic calc storage property?

You are designing the storage properties for your Planning application. What two design principles
should you follow related to the dynamic calc storage property?

You are designing the storage properties for your Planning application. What two design principles
should you follow related to the dynamic calc storage property?

A.
Dynamically calculated members should roll up to stored members.

B.
You cannot calculate and store dynamic calculated members in calc scripts and business rules.

C.
Consider dynamic calc members on sparse parents with 100 t children.

D.
Tagging upper-level members of sparse dimensions can reduce block size.

E.
If you use a large number of dynamic calcs, you should consider increasing the Dynamic
Calculator Cache.

F.
Consider Dynamic Calc and Store over Dynamic Calc.

Explanation:
B:
“If you specify a Dynamic Calc or Dynamic Calc and Store member explicitly in a calculation script,
the calculation script fails. You cannot do a calculation script calculation of a Dynamic Calc or
Dynamic Calc and Store member. To use a calculation script to calculate a member explicitly, do
not tag the member as Dynamic Calc.
E: The dynamic calculator cache is a buffer in memory that Essbase uses to store all of the blocks
needed for a calculation of a Dynamic Calc member in a dense dimension (for example, for a
query).
Incorrect answer:
F: Storing the information is no advantage in this scenario.



Leave a Reply 1

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