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

Question 1

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. 3, 1, 2

B. 3, 2, 1

C. 1, 2, 3

D. 2, 3, 1

Correct Answer: A

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 2

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. Use data suppression on the data form.

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

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

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

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

Correct Answer: D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 3

What are the three supported methods to create and update a member and its properties (assuming Classic or non-Classic Planning applications)?

A. EPMA

B. Outline Load Utility

C. DRM

D. EAS

E. Planning Web Client

Correct Answer: A,C,D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 4

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 user has read access to the members on the data form.

B. The planning unit is set to first pass.

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

D. Another user owns the planning unit.

E. The form is set to Read Only.

Correct Answer: A,C,E

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 5

Identify the three true statements about weekly distribution.

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. Weekly distribution determines how data entered into summary periods should spread to its base periods.

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

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

E. 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.

Correct Answer: A,B,E

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 6

Identify two ways that Essbase data load rules cannot manipulate source data files.

A. Find and replace manipulations on source records.

B. Select or reject records based on certain criteria.

C. Flip the sign for records with a certain member tagged with a comment.

D. Split or join columns in a source.

E. Map data based on an external table.

Correct Answer: A,D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 7

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

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

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

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

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

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

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

Correct Answer: C,E,F

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 8

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

A. enter supporting detail and cell text.

B. enter planning unit annotations.

C. Perform workflow tasks.

D. Open a data form and submit data.

E. Run business rules.

Correct Answer: A,D,E

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Welcome to TestSimulate

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