Weekend Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70percent

Oracle 1z0-533 Oracle Hyperion Planning 11 Essentials Exam Practice Test

Demo: 10 questions
Total 69 questions

Oracle Hyperion Planning 11 Essentials Questions and Answers

Question 1

You have a new Planning administrator to manage the Capital Expenditure application. He will assign security for the application as well as maintain dimensions in EPMA, Business Rules in Calculation Manager, and load data via Essbase rules files. He will not need access to other applications. Choose the two valid roles that will address part or this entire requirement.

Options:

A.

Administrator for the CapEx application

B.

Administrator for the Planning Server

C.

Provisioning Manager for the CapEx application

D.

Planning Calculation Manager for the CapEx application

E.

Dimension Editor for the CapEx dimensions

F.

Application Manager in Essbase for the CapEx dimensions

Question 2

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

Options:

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.

Question 3

You have the following design requirement: You need to track customer status For a sales planning application. Valid options for customer status include: Active, Inactive, Out of Business. 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

Question 4

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

Question 5

Identity the true statement about Custom Menus.

Options:

A.

Custom menus can provide links to data forms, Business Rules, URLs, and Planning preferences.

B.

Custom menus require Java scripting knowledge to create.

C.

You can assign security to custom menus so that only specific users or groups can see the custom menu.

D.

Custom menus are assigned to data forms only.

E.

Custom menus are limited to a single list of tasks; you cannot group them into sub categories.

Question 6

In a non-multicurrency Planning application, what three things happen if all options are checked for Refresh Database?

Options:

A.

Dimension and member changes are pushed to Essbase.

B.

Cell text and supporting detail changes are pushed to Essbase.

C.

Security filters for dimensions and members are pushed to Essbase.

D.

Security filters for shared members are pushed to Essbase.

E.

Data changes are pushed to Essbase.

Question 7

What option contributes to making an Enhanced Calc Script more flexible than a native Essbase Calc Script?

Options:

A.

Run on Save

B.

@CALCMODE function

C.

Run time prompts

D.

Can be run over the web

E.

Substitution Variables

F.

Custom Defined Functions

Question 8

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?

Options:

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.

Question 9

You are designing a form for fast retrieval speed. Assuming a plan type with two dense dimensions and four sparse dimensions, what is the optimal layout?

Options:

A.

Sparse dimensions in Page and POV, Dense dimensions in Rows and Columns

B.

Sparse dimensions in Rows and Columns, Dense dimensions in Page and POV

C.

Sparse dimensions in Page and Columns, Dense dimensions in Rows and POV

D.

Sparse dimensions in Page and Rows, Dense dimensions in POV and Columns

E.

The layout of sparse and dense dimensions has no impact on form performance; only the number cells on a data form impacts form performance.

Question 10

Identify the two true statements with regard to Versions and Scenarios.

Options:

A.

Versions control data entry based on time periods set by the administrator.

B.

There is only one Version to one Scenario.

C.

Versions allow several "what-if" Scenarios.

D.

Users must have the same security settings in the Version dimension as they have in the Scenario dimension.

E.

Versions can be top down or bottom up.

Demo: 10 questions
Total 69 questions