Question 1

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

Options :

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.

Answer: B,E

Question 2

Identify the two true statements about a sparse Entity dimension In Hyperion Planning.

Options :

A : You cannot build alternate rollups or assign custom attributes.

B : Base currencies are assigned to entity members.

C : Exchange rates are assigned to entity members

D : Entity along with Scenario and Period make up a planning unit.

E : Entity along with Scenario and Version make up a planning unit.

Answer: B,E

Question 3

Management dictates a major reorganization of the company structure, meaning you need to rebuild the Entity dimension from the beginning. You need to delete members in the Entity dimension. Identify the three true statements about deleting members from a Planning application.

Options :

A : You must delete members one by one.

B : You must delete a reference to a member from all data forms before deleting it from the dimension.

C : In a data form definition, you selected @IDescendants(IT) for the entity dimension in the page section. The IT member will remain but 2 of its 10 cost centers are being removed. You must remove the reference to "IT" in this data form.

D : You should back up all data for the deleted entity members; after a member is deleted, the data is not retained. E. A database refresh is required after deleting members from the Entity dimension.

E : A database refresh is required after deleting members from the Entity dimension

Answer: B,D

Question 4

Identify the two true statements about shared members.

Options :

A : You can assign a custom attribute value to a shared member.

B : You can define a member formula for a shared member.

C : You can assign security rights to a shared member.

D : There is no limit to the number of shared members that you can create for the base member.

E : Shared members may be defined for Accounts and Entity dimensions only.

Answer: C,D

Question 5

The budget office analyst needs to enter and plan data, use the Planning spreading feature that allow users to spread budget data based on last year's actuals, and modify data forms. What two roles should be provisioned for this user?

Options :

A : Grid Spread

B : Planner

C : Interactive User

D : Mass Allocate

E : Offline User

Answer: B,C