Free Oracle Hyperion Planning 11 Essentials 1Z0-533 Exam Practice Test

You need to build the Entity into your Classic Planning application. You can dynamically build theEntity dimension in the Planning application via:1-Essbase load rules2-Oracle Data Integrator (ODI)3-Data Integration Management (DIM)4-Data Relationship Management (DP.M)5-Outline Load Utility6-EPMA

• 2, 3, 6
• 2, 3, 5
• 1,2,3,5
• 1, 2,3,4,5
• 2, 3
• 1, 2, 3,4,5,6

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

• Reduce the number of rows and columns displayed in the data form.
• Upgrade the client machine's operating system processing speed and RAM.
• In the data form definition, remove the option to display alias.
• Reduce the number of page dimensions used on the Web form
• Tune the index and data caches inEssbase.

Product status is a data element you need to include in your Planning application. Each productwill have a product status that can vary over time. You will use product status in calculations andwill need to report sales by product status and across products in a cross tab f. r I m in.What is the best way to meet all of these requirements?

• Define Product Status as a Smart List.
• Define Product Status as a Separate Dimension.
• Define Product Status as an Attribute.
• Define Product Status as a Varying Attribute.
• Define Product Status as an alternate hierarchy in the Product dimension.

You need to create an allocation Business Rule that allocates marketing expense from corporatedown to each region based on FYIO actuals for the Budget scenario. What is the correct formulaassuming this syntax is used in an enhanced calc script?

• FIX (Budget, 0LEVMBRS (Market,0)) 'Marketing expense' = 'Marketing expense '->Corporate * ('Marketing expense' Actual / 'Marketing expense' -> Actual -> TotalMarket); ENDFIX
• FIX (Budget, (3LEVMBRS (Market, 0) ) ) 'Marketing expense' = 'Marketing expense'->Corporate * ('Marketing expense'/'Marketing expense' -> TotalMarket) ; ENDFIX
• FIX (Budget, (3LEVMBRS (Market, 0) ) --- 'Marketing expense' = 'Marketing expense'->Corporate * ('Marketing expense Actual ->FY10 / 'Marketing expense' -> Actual ->FY10 TotalMarket); ENDFIX
• FIX (OLEVMBRS (Market, 0) ) 'Marketing expense' = 'Marketing expense'~>Corporate * (^Marketing expense Actual ->FY10 / 'Marketing expense' -> Actual ->FY10 TotalMarlket); ENDFIX

Identify the three true statements about the CapEx Planning module.

• Is a prebuilt plan type focused on capital expense relatedplanning
• Provides complete out-of-the-box functionality forcapex planning including dimensions, data forms, business rules and security
• Can be initialized within an existing Planning application
• Can be created as a stand-alone application
• Because planning limits an application to three plan types,Capex Planning must be the third plan type.

Planning utilizes which type of database to store data (for example, 'the numbers')?

• Block Storage OptionEssbase database
• Aggregate Storage OptionTssbase database
• Relational database
• XOLAP database
• Proprietary database

What are the correct predefined types of base time periods that can be established when creatingthe calendar in a planning application?

• Weekly, Monthly, Quarterly, Custom
• Monthly, Quarterly, Custom
• Monthly, Quarterly, Weekly
• Weekly, Monthly, Quarterly, Yearly, Custom
• Only Custom periods are possible.

Identify the two true statements about Enterprise performance Management Architect.

• If you decide to implement EPMA, all Planning applications must be f PMA-deployed applications.
• EPMA-deployed applications may either use EAS Business Rules or Calculation Manager in 11.1.1.3.
• You can create Planning, TM,Essbase, and FDM applications in FPMA.
• Data can be shared from a Planning application to an FM application within EPMA.
• EPMA can be used by end users to manage and update member properties such as hierarchies and aliases.
• In the Dimension Library, you can maintain one full dimension (for example. Account) but filter portions of the dimension for different applications (for example, Revenue accounts. Balance Sheet),

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

• Grid Spread
• Planner
• Interactive User
• Mass Allocate
• Offline User

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

• The business rule has not been assigned to the data form.
• The business rule was created for another plan type.
• The valid locations have not been defined for the business rule.
• The valid locations have not been defined for the data form.
• The Validate and Launch privileges have not been granted for the business rule.
• The Validate and Launch privileges have not been granted for the data form.