11.11 Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Free and Premium Oracle 1z0-533 Dumps Questions Answers

Page: 1 / 3
Total 69 questions

Oracle Hyperion Planning 11 Essentials Questions and Answers

Question 1

Fragmentation in an underlying Planning Essbase database that is caused by what two actions?

Options:

A.

Delete member from a sparse dimension.

B.

Delete member from a dense dimension.

C.

Renaming a member.

D.

Renaming an alias.

E.

Submitting data / deleting data frequently.

Buy Now
Question 2

Identify the three true statements about attribute dimensions.

Options:

A.

Planning supports hierarchies and aliases for attribute dimensions.

B.

Planning supports all attribute types (for example. Boolean, Date, Text).

C.

Planning supports varying attributes (where an attribute can vary over one or more other dimensions).

D.

Attribute dimensions can be assigned to dense dimensions.

E.

Attribute dimensions may only be assigned to one base dimension.

Question 3

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.

Question 4

Identify the three true statements about weekly distribution.

Options:

A.

For Weekly Distribution options 445, 454, 544, the quarterly values are treated as if they are divided into 13 weeks and the weeks are distributed via a pattern you specify.

B.

The only valid weekly distribution options are 445, 454, and 544.

C.

If you select the 4-5-4 Weekly distribution option, Planning treats the first month in the quarter as if it has 4 weeks, the second month as If it has 5 weeks, and the third month as if it has 4 weeks.

D.

If you choose weekly distribution for Custom-based time periods. Planning will not distribute the data values across base periods.

E.

Weekly distribution determines how data entered into summary periods should spread to its base periods.

Question 5

Given the following:

Measures (Dense): 40 stored members, 50 total members

Time (Dense): 17 stored members, 17 total members

Scenario (Dense): 2 stored members, 5 total members

Market (Sparse): 100 stored members, 100 total members

Product (Sparse): 500 stored members, 550 total members

How 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

Question 6

You are designing a new Planning application. Which two requirements dictate multiple plan types in a single Planning application?

Options:

A.

Multiple currencies are required.

B.

Currency rates must be kept in a separate database.

C.

Sales are planned by product and channel, and salary expenses are planned by position.

D.

Security is applied to the Entity dimension but can differ for users for accounts "sales" and "expenses".

E.

You have decided to implement the Capital Expense planning module in addition to PSL budgeting.

F.

Data cannot be shared across the Organization dimension.

Question 7

Identify the one Planning component that is not accessible over the Web.

Options:

A.

Dimension Editor for Planning

B.

Shared Services

C.

Exchange Rates Definition

D.

Planning Utilities

E.

Create and Manage Database Options

F.

Create Data Sources

Question 8

What are two user interfaces to Planning data forms?

Options:

A.

EPM Workspace

B.

Excel Add-in

C.

Smart View Essbase Provider

D.

Smart View Planning Provider

E.

Planning ADM Driver for FR

Question 9

Which three tasks can be performed using the Smart View Planning Provider in Microsoft Excel?

Options:

A.

Open a data form and submit data.

B.

enter supporting detail and cell text.

C.

Run business rules.

D.

enter planning unit annotations.

E.

Perform workflow tasks.

Question 10

You have a measure in your Accounts dimension for "Price". Price Is Input by users (along with Units). Sales is calculated as Units * Price. Identify the correct property that should be assigned to Price to meet this requirement.

Options:

A.

Stored

B.

Dynamic Calc

C.

Dynamic Calc and Store

Page: 1 / 3
Total 69 questions