Question 1

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 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

In the Workforce Planning module, an employee is terminated. What two activities do you perform in WFP, so that total salary numbers are correctly calculated?

Options :

A : Run a business rule to change the employee's status.

B : Change the employee's status on a data form using the Smart List drop down.

C : Change the employee's status on a data form using the free form text measure.

D : Change the employee status attribute association in the Employee dimension.

E : Delete the employee from Workforce Planning.

Answer: A,B

Question 4

What differentiates a user-defined custom dimension from the Entity and Account dimensions?

Options :

A : You can only add custom attributes to user-defined custom dimensions.

B : You assign valid plan types for the user-defined custom dimension at the dimension level.

C : You assign data types for the user-defined custom dimension at the dimension level.

D : You cannot: assign security for user-defined custom dimensions.

E : You can easily delete a user-defined custom dimension in Planning but you cannot delete an Entity dimension.

Answer: B

Question 5

Given the following:Measures (Dense): 40 stored members, 50 total membersTime (Dense): 17 stored members, 17 total membersScenario (Dense): 2 stored members, 5 total membersMarket (Sparse): 100 stored members, 100 total membersProduct (Sparse): 500 stored members, 550 total membersHow many potential blocks could be created?

Options :

A : Potential Blocks = 40 * 17*2

B : Potential Blocks = 40* 17*2*8

C : Potential Blocks = 100 * 500

D : Potential Blocks = 100 * 500 * 8

E : Potential Blocks = 100 * 550

F : Potential Blocks = 100 * 550 * 8

Answer: C