Question 1

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

Question 2

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 3

Identify three key benefits of the Planning solution.

Options :

A : Standardized data forms for plan data entry available both for the Web and in Excel

B : One tool to budget and forecast as well as provide reporting for very detailed Actuals Information

C : Central repository of business rules that can be run by end users to calculate plan data

D : Detailed security down to the cell level

E : Flexible solution customizable for almost any kind of budgeting and forecasting process

Answer: A,C,E

Question 4

You have the following design requirement: You need to track customer status For a salesplanning application. Valid options for customer status include: Active, Inactive, Out ofBusiness. Customer status can change on a month-by-month basis.What is the best way to build Customer Status into the Planning application?

Options :

A : Attribute dimension

B : Varying attribute dimension

C : Smart List

D : Free Form Text

E : Alternate hierarchy

Answer: C

Question 5

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