1Z0-533 Online Practice Questions and Answers

Correct Answer: ACD

During refresh:

*

Essbase security filters are updated (C, D)

*

Currency conversion calc scripts are updated

*

Accounts or associated properties are propagated from the relational database to the Essbase database

*

Custom attributes are added, modified, or deleted in the Essbase database

*

Exchange rate values are repopulated in the Essbase outline

*

Member formulas for certain accounts are generated or updated

*

Additions or changes to alias tables and their association to dimensions or members are updated (A)

*

The Essbase database is restructured

*

UDAs are added to the Essbase database

Reference: Oracle Hyperion Planning, Fusion Edition, Creating and Refreshing Application Databases

Correct Answer: BC

Planner:

The majority of Hyperion Planning users are planners who are responsible for department or project budgets. They conveniently work over the Web or the Spreadsheet Add-in to:

Enter, submit, and view data

Use pre-defined policies, procedures, routines, reports, and worksheets to enter, analyze, and report on application data

Interactive User:

Examples of an interactive user include a department head, sales director, or unit manager who submits budget information and data for approval. Interactive users can enter and view data. They can also create, maintain, and initiate:

Data entry forms on the Web

Spreadsheet Add-in worksheets

Reports using Hyperion Reports

Integrations using Hyperion Application Link

Business rules using Hyperion Business Rules

Correct Answer: BE

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.

Correct Answer: ABD

A: Specify access rights to members of the Scenario dimension for groups or users.

Access rights determine users or groups can view or modify data. A user or group can have only one of these access rights: Read, Write, or None. Access rights for a user can be combined based on groups to which the user belongs.

B: When creating a scenario For Start Yr., Start Period, End Yr., and End Period are used to select the time period to associate with the scenario.

D: The Scenario dimension has an Exchange Table property with value of the name of an exchange rate table defined in the application.

Reference: Oracle Hyperion Planning, Fusion Edition

Correct Answer: D

Hyperion Planning Utilities can only be used locally.

Correct Answer: ABC

Oracle Hyperion Smart View for Office (Smart View) is a component of Hyperion Foundation Services. Smart View provides a common Microsoft Office interface designed specifically for Oracle's Enterprise Performance Management (EPM) and Business Intelligence (BI). Using Smart View, you can view, import, manipulate, distribute and share data in Microsoft Excel, Word and PowerPoint interfaces. It is a comprehensive tool for accessing and integrating EPM and BI content from Microsoft Office products.

Correct Answer: A

Scenarios and versions are the basis of the planning review cycle. Entities submit planning data for a particular scenario and version. The combination of scenario, version, and entity is called a planning unit and is the basic unit for preparing, reviewing, and approving plan data.

Reference: Hyperion System 9 Planning, Planning Units

Correct Answer: ABE

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.

Correct Answer: AD

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.

Correct Answer: ACDE

A: To add supporting detail that calculates values in a data form:

1 Open a data form in Excel,

2 In the data form, select the data cells for which you want to add detail.

3 Select Hyperion > Supporting Detail. For Office 2007, click Supporting Detail in the Task section of the Hyperion ribbon.

4 Etc.

7. Enter data for the items for which you want to set or calculate values.

When you enter numbers into the Supporting Detail window, use the scaling that was set up for the data values in the data form.

8 Click OK.

Values are dynamically calculated and aggregated before the data is saved.

C: Supporting detail can include text, values, and operators that define how data aggregates.

Supporting detail also provides a way to drill down into data to better understand its basis. For example, if the bottom-level member in your outline is pens, you can add line items in supporting detail for ballpoint, fountain, marker, and so on. Then you can aggregate the detail values to the pen member in the outline.

D:Oracle Hyperion Smart View for Office (Excel, PowerPoint, Word, and Outlook), are some of the various Oracle tools that enable users to interact with an Oracle Essbase application.

Oracle Hyperion Smart View for Office (Smart View) is a component of Hyperion Foundation Services. Smart View provides a common Microsoft Office interface designed specifically for Oracle's Enterprise Performance Management (EPM) and Business Intelligence (BI). Using Smart View, you can view, import, manipulate, distribute and share data in Microsoft Excel, Word and PowerPoint interfaces. It is a comprehensive tool for accessing and integrating EPM and BI content from Microsoft Office products.

E: In Planning applications, when you delete supporting detail for a cell, you affect the associated value in the relational database. You specify how to handle the stored Essbase value.

Note (on A and E): To synchronize supporting detail with Essbase:

1 Open a data form in Excel

2 In the data form, click the cell that has the supporting detail you want to remove.

3 Select Hyperion > Supporting Detail. For Office 2007, click Supporting Detail in the Task section of the Hyperion ribbon.

4 In the Supporting Detail window, delete the information, then click OK.

5 Select an option from the displayed message to specify how to handle the aggregate value of the deleted

supporting detail stored in Essbase:

To delete the value from Essbase, click Yes, set the value(s) to #Missing.

To leave the data value in Essbase as is, click No, leave the value(s) as is.

Correct Answer: CE

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.

Correct Answer: ABCDE

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.

Reference: Required Dimensions for a Hyperion Planning Application

Correct Answer: B

Set the time balance as "last" when you want the parent value to represent the value of the last member in the branch (often at the end of a time period).

Note:

Essbase - Time balance properties

The tags :

first,

last,

average,

and expense

are available exclusively for use with accounts dimension members.

Using this tag requires an accounts dimension and a time dimension

If an accounts dimension member uses the time balance property, it affects how Essbase calculates the parent of that member in the time dimension. By default, a parent in the time

dimension is calculated based on the consolidation and formulas of its children. For example, in the database in this scenarion, the Q1 member is the sum of its children (Jan, Feb, and Mar). However, setting a time balance property causes

parents, for example Q1, to roll up differently.

If you set the time balance as first, last, or average, set the skip property to tell Essbase what to do when it encounters missing values or values of 0.

Correct Answer: C

Attribute: Characteristic of a dimension member. For example, Employee dimension members may have attributes of Name, Age, or Address. Product dimension members can have several attributes, such as a size, Status, and flavor.

Reference: Oracle Hyperion Planning, Fusion Edition, Release 11.1.1.3

Correct Answer: AE

A: In all Planning Units states except the Not Started state, users with read access can view data, view the process state, view the history, and read and enter annotations.

E: The Administrator have full access.

Reference: Reference: Oracle Hyperion Planning, Fusion Edition, Release 11.1.1.3, Overview of the Review Process