Oracle 1z0-533 Exam Made Easy: Step-by-Step Preparation Guide

C: Access cannot be assigned directly to a shared member. You assign access rights to shared members in one of two ways:

* From the security assigned directly to the base member

* From the security assigned at the parent or ancestor of the shared member

D: You can create multiple shared members for the base member. A base member must exist before you can create a shared member, but there is no limit to the number of shared members you can create for the base member.

E: Shared members are available for Entity, Account, and user-defined custom dimensions.

" Shared members contain read-only values and are only available in the Entity dimension. "

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.

B:

"If you specify a Dynamic Calc or Dynamic Calc and Store member explicitly in a calculation script, the calculation script fails. You cannot do a calculation script calculation of a Dynamic Calc or Dynamic Calc and Store member. To use a calculation script to calculate a member explicitly, do not tag the member as Dynamic Calc.

E: The dynamic calculator cache is a buffer in memory that Essbase uses to store all of the blocks needed for a calculation of a Dynamic Calc member in a dense dimension (for example, for a query).

Incorrect answer:

F: Storing the information is no advantage in this scenario.

Planning data forms can be accessed from within the EPM Workspace and from Smart View Planning Provider.

Note: Smart View provides a common Microsoft Office interface for Oracle Essbase, Oracle Hyperion Financial Management, Fusion Edition, Oracle Hyperion Planning, Fusion Edition, Oracle Enterprise Performance Management Workspace, Fusion Edition, Oracle Business Intelligence Enterprise Edition, and Oracle's Hyperion® Enterprise® data. Using Smart View, you can view, import, manipulate, distribute and share data in Microsoft Excel, Word, and PowerPoint interfaces.

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.

You candynamically build the Entity dimension in the Planning applicationwith the help ofODI, DIM and EPMA.

With Version 11(and later)you can also use the outline loader.

Incorrect:

not A:you can't use essbase load rules, metadata has to be loaded to planning and then pushed to essbase.

Stored should be used.

Note: The accounts dimension is a dimension type that makes accounting intelligence available. Only one dimension can be defined as Accounts.

A: If the user does not have the launch the Business Rules role, it could prevent the user from seeing the rule.

B: The Validate or launch Privilege enables a users or users you specify to validate and launch the business rule sequence

Incorrect answer:

C: The business rule has already been assigned to the Data Form.

Administrators can use Copy Data to copy plans from one dimensional intersection to another (A), including relational data and supporting detail (C).

You can copy account annotations (E), supporting detail, and cell text (D). You cannot copy

planning unit annotations.

Administrators use Smart Lists to create custom drop-down lists that users access from data

form cells. When clicking into cells whose members are associated with a Smart List (as a member

property), users select items from drop-down lists instead of entering data. Users cannot type

in cells that contain Smart Lists. Smart Lists display in cells as down arrows that expand when

users click into the cells.

Perform these tasks to create and administer Smart Lists:

* Define Smart Lists

* Associate Smart Lists with members.

* Select dimensions for which Smart Lists are displayed.