Q1. Why is the Create Blocks function in calc scripts and Business Rules important in Planning? 

A. Data may not exist for the combination of dense members so you have to create the block before calculating the data value for the block. 

B. Data may not exist for the combination of sparse members so you have to create the block before calculating the data value for the block. 

C. Data may not exist for the combination of dense members so you have to create the block before block loading data to the block. 

D. Data may not exist for the combination of sparse members so you have to create the block before loading data value to the block. 

View Answer

Q2. When opening a data form, the user experiences slow performance. What three steps could you do to improve the time it takes to open the data form? 

A. Reduce the number of rows and columns displayed in the data form. 

B. Upgrade the client machine's operating system processing speed and RAM. 

C. In the data form definition, remove the option to display alias. 

D. Reduce the number of page dimensions used on the Web form 

E. Tune the index and data caches in Essbase. 

View Answer

Q3. Assuming EAS Business rules, a user cannot see a business rule on a data Form. What are three possible causes? 

A. The business rule has not been assigned to the data form. 

B. The business rule was created for another plan type. 

C. The valid locations have not been defined for the business rule. 

D. The valid locations have not been defined for the data form. 

E. The Validate and Launch privileges have not been granted for the business rule. 

F. The Validate and Launch privileges have not been granted for the data form. 

View Answer

Q4. What four prebuilt actions are available In EAS Business Rules? 

A. Aggregate 

B. Copy Data 

C. Clear Block 

D. Clear Data 

E. Create Block 

F. Allocate 

View Answer

Q5. The Hyperion Planning administrator needs to run several calculations in a specific order against two different databases within the application. Identify the two options that are not valid. 

A. Esscmd 

B. Calc Script 

C. Business Rule Sequence 

D. MaxL 

E. Business Rule Macro 

View Answer

Q6. Assuming the following dimensions and members: 

Scenario - Actual, Budget and Year - 2010, 2011, you need to create a data form with two columns. One column should list Actual for 2010 and the second column should list Budget 2011. You do not want to show data for Actual 2011 even though the first three months of the year have been loaded from the GL. 

What is the best way to only show the 2 columns in the data form? 

A. You cannot build a data form with these two columns, hour columns will display: Actual >2010, Actual >2011, Budget->2010 and Budget >2011 

B. Use Segments on the data form to create the asymmetric columns. 

C. Use User Variables on the data form to create the asymmetric columns. 

D. Use a composite data form to meet this requirement. 

E. Use data suppression on the data form. 

View Answer

Q7. A planner is supposed to be able to submit data within a data form. 

What are all the possible causes for an end user not being able to enter data on a data form? Select all that apply. 

A. The planning unit is set to first pass. 

B. Another user owns the planning unit. 

C. The user has read access to the members on the data form. 

D. The form contains summary-level members in a bottom up version. 

E. The form is set to Read Only. 

View Answer

Q8. Identify the true statements regarding Supporting Detail. Select all that apply. 

A. Importing Supporting Detail from Excel is supported. 

B. Supporting Detail must be entered cell by cell; entry for multiple columns at once is not possible 

C. Supporting Detail can contain a hierarchy with an aggregation of values for that hierarchy. 

D. Supporting Detail can be viewed using the Smart View Add-in Essbase Provider. 

E. Supporting Detail is stored in Essbase. 

View Answer

Q9. Identify the two true statements about shared members. 

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. 

View Answer

Q10. Identify the three true statements about the CapEx Planning module. 

A. Is a prebuilt plan type focused on capital expense related planning 

B. Provides complete out-of-the-box functionality for capex planning including dimensions, data forms, business rules and security 

C. Can be initialized within an existing Planning application 

D. Can be created as a stand-alone application 

E. Because planning limits an application to three plan types, Capex Planning must be the third plan type. 

View Answer