oracle 1z0-533 practice test

Oracle Hyperion Planning Exam


Question 1

What are the two possible effects on the database when the data storage property of a parent
member in the sparse Entity dimension is set to Dynamic Calc?

  • A. Essbase data block size decrease*.
  • B. The member is not available for process management.
  • C. Retrieval performance could be slower when referencing the parent entity member.
  • D. Data cannot be input to the parent in target versions.
Answer:

A,C

Discussions

Question 2

A Planning Unit has a status of First Pass; what two user types can input data?

  • A. Anyone with write access to the planning unit
  • B. Anyone with write access to the planning application
  • C. Anyone with read or write access to the planning unit
  • D. The owner of the planning unit
  • E. The administrator
Answer:

A,D

Discussions

Question 3

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.
Answer:

D,E

Discussions

Question 4

You've created an EAS business rule and assigned it to the data form but an end user can't see it.
What are two valid reasons?

  • A. The user doesn't have the Launch Business Rules role in Shared Services.
  • B. The user hasn't been assigned Validate and Launch Privileges in EAS.
  • C. The location for the Business Rule hasn't been defined.
  • D. The user hasn't been assigned access to the Business Rule in the Planning Web client.
Answer:

A,B

Discussions

Question 5

What are valid data types for the Accounts dimension?
1 -Currency
2-Non-currency
3-Percentage
4-Saved Assumption
5-Text
6- Smart List
7-Date

  • A. 1, 2, 3, 4, 5, 6, 7
  • B. 1, 2, 3, 5, 6, 7
  • C. 1, 2, 3, 6
  • D. 1, 2, 3, 4, 6, 7
  • E. 1, 2, 3, 4, 6
Answer:

B

Discussions

Question 6

In the Workforce Planning module, an employee is terminated. What two activities do you perform
in WFP, so that total salary numbers are correctly calculated?

  • A. Run a business rule to change the employee's status.
  • B. Change the employee's status on a data form using the Smart List drop down.
  • C. Change the employee's status on a data form using the free form text measure.
  • D. Change the employee status attribute association in the Employee dimension.
  • E. Delete the employee from Workforce Planning.
Answer:

B,E

Discussions

Question 7

A Business Rule is launched from a data form. What will Planning utilize to provide a valid list of
members for a run-time prompt?

  • A. Members defined on the data form
  • B. Planning Metadata security
  • C. Business Rules security access privileges
  • D. Essbase security filters
  • E. Business Rules Basic User Role
Answer:

A

Discussions

Question 8

Product status is a data element you need to include in your Planning application. Each product will
have a product status that can vary over time. You will use product status in calculations and will
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?

  • A. Define Product Status as a Smart List.
  • B. Define Product Status as a Separate Dimension.
  • C. Define Product Status as an Attribute.
  • D. Define Product Status as a Varying Attribute.
  • E. Define Product Status as an alternate hierarchy in the Product dimension.
Answer:

C

Discussions

Question 9

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.
Answer:

A,D,F

Discussions

Question 10

You need to calculate benefit expense in your Planning application using the following logic:
Benefit expense is equal to the Total Salary of the Organization multiplied by a factor data loaded to
each cost center.
Given the following components, what is the correct order of calculation:
1-Custom calculation (Total Salary * Factor)
2-Aggregate benefits
3-Aggregate salaries

  • A. 1, 2, 3
  • B. 3, 2, 1
  • C. 2, 3, 1
  • D. 3, 1, 2
Answer:

D

Discussions
To page 2