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

Data types:

How values are stored and displayed:

*Currency (A)

*Non-Currency (B)

*Percentage (C)

*Smart List (F)

*Date (G)

*Text (E)

*Unspecified

F

or accounts, if Data Type is set to any value except Currency, you must set Exchange Rate Type

to None.

Note:

The accounts dimension is a dimension type that makes accounting intelligence available. Only one dimension can be defined as Accounts.All members in the accounts dimension inherit the accounts property. You can create an outline that does not have an accounts dimension.

A: If you select a weekly distribution pattern other than Even, Planning treats quarterly values as if they were divided into 13 weeks and distributes weeks according to the selected pattern.

E:

Weekly distribution sets the monthly distribution pattern, based on the number of fiscal weeks

in a month. This determines how data in summary time periods spreads within the base time

period. When users enter data into summary time periods, such as quarters, the value is

distributed over base time periods in the summary time period.

C: When you define an entity member, you assign a plan type for which it is valid. If you do not

assign a plan type to a member, that member’s children do not have access to that plan type. If

you move a member, and the new parent of that member is valid for different plan types, then

the member remains valid only for the plan types it has in common with the new parent.

Your organization may require that different entity members prepare different plans. For

example, in your organization all entity members may submit expense plans, but entity

members that are cost centers do not submit revenue plans. When you define entity members

you specify the plan types for which they are valid. Because data forms are associated with plan

types, this allows you to control which entity members can enter data for each plan type.

E: You would need two plan type. To add a Capital Expense plan type to an existing application see Note below.

Note: To add the Capital Asset Planning plan type to a Planning application:

1 In Performance Management Architect, select Navigate, then Administer, then Application Library.

2 In the Application Library, right-click the application to which you want to add the Capital Asset Planning

plan type, select Initialize, then select Capital Asset or Workforce and Capital Asset if the application will use both plan types.

3 To confirm the initialization, click Yes.

After you establish or update user and group security, the Planning application needs to be

refreshed to complete the update to Analytic Services security filters.

Incorrect:

D: This options badly worded. We here assume that the security of the member has not changed.

C, E: no security has changed.

B: members of the dimension entity must be first delete in data forms and then in the library dimension

D: Make a backup to retain the information.

E: A refresh of the database is required.

Custom menus can be used to launch the following:

– Business Rules

– Context sensitive data forms

– URL

– Context sensitive Process Management

An Enhanced Calc Script is a calc script created with Business Rules that contains run-time prompts.

A: Reducing the amount of rows and columns that need to be accessed would increase performance.

B: The client machine could also be a bottleneck.

E: Indexing and caching would help when loading data into a form.

The required dimensions for a Hyperion Planning Application.

Required Dimensions:

Period

Year

Scenario

Version

Entity

Account

Other Dimensions:

Alias

Smart Lists

Multicurrency applications require two additional dimensions:

Currency

HSP_Rates

Note:

Period and Year

You specify a time period and year for each value. Base time periods, such as months, are automatically rolled up to summary time periods, such as quarters and total year. As administrators, you specify base time periods and distribution of weeks in the Period dimension when you create application views. You use the year dimension to add years to the calendar.

Scenario and Version

The Scenario and Version dimensions represent the broadest categories of data in your application. Scenario describes the type of data that a plan includes, such as budget, actual, or forecast, as well as the time span that the plan covers.

Version allows for flexibility and iterative planning cycles. For example, your application could have two versions, Working and Final, for each scenario. You can also use versions to model possible outcomes based on different assumptions about interest rates, growth rates, and so on. For example, your application an have a Best Case and Worst Case version for each scenario.

Entity

The Entity dimension represents the flow of Planning information through your organization. You can establish an entity for each group or responsibility center that submits a budget plan. These units could be geographic regions, departments, or divisions, depending on your requirements.

Account

The Account dimension specifies the data to be collected from budget planners. You can establish accounts for all budgeted items to the necessary level of detail. Examples of accounts are Rent Expense and Cash on Hand.

Currency

You can plan in one or more currencies. The Currency dimension identifies the currency in which values are displayed. In the Currency dimension, you set up the following categories:

* Which currencies are used by applications and reporting

* How currencies are displayed in reports and data forms

* How currencies are translated into other currencies

* When currency conversion occurs

HSP_Rates

This dimension contains a member to store exchange rate values for each currency. It also contains a member for input values and currency overrides.

Alias and Smart Lists

In addition to the required Planning dimensions, you must set up an Alias dimension if you want to assign aliases to dimensions such as Account or Entity. If you want to use Smart Lists in your application, you must set up a Smart List dimension.

User-defined custom dimensions differ from the Entity and Account dimensions in that you

assign valid plan types at the dimension level, not at the member level. All members of a user defined custom dimension are valid for plan types assigned at the dimension level.