1Z0-532 Oracle Hyperion Financial Management 11 Essentials Exam (Exam 2)

Questions
Reviews

Identify the correct sequence for building a Classic FM application:1-Create the a...

Identify the correct sequence for building a Classic FM application:
1-Create the application shell.
2-Create an application profile.
3-Define metadata such as dimensions and application settings. 4-Load data, data forms, member lists,
rules, and journals.
5-Define security.

1, 2, 3, 4, 5

1, 2, 3, 5, 4

1, 2, 5, 3, 4

2, 1, 4, 3, 5

2, 1, 5, 3, 4
Identify two true statements about the native data load file format.

Identify two true statements about the native data load file format.

The default column order for the native data file is Scenario, Year, Period, View, Entity, Value, Account,
ICP, Custom1, Custom2, Custom3, and Custom4.

The Group section is required.

The Line Items detail section contains data values.

You cannot change the column order for the data file.

The Group section defines the POV for the data file; you can define only a single member for each POV
dimension.
Identify the two true statements about rule types in FM.

Identify the two true statements about rule types in FM.

The Dynamic rule type allows you to calculate both parent and base accounts.

Calculation rules are run only with FM specific calculation commands in Financial Management; no
general VB commands.

If you need to calculate Gross Margin %, use the Translate rule type.

The NoInput rule type prevents users from entering data into specific cells or slices of cells using
Hs.Nolnput.

Calculate, Dynamic, Allocation, Input, No Input, Translate, Consolidate, Transactions, and Equity pickup
are all valid rule types.
Given the following syntax in a business rule:Identify the two variables.

Given the following syntax in a business rule:
Identify the two variables.

strPOV

Hs.Exp

Calculate ()

strview

DIFFERENCE
Identify the three true statements about Dimension Associations in EPMA.

Identify the three true statements about Dimension Associations in EPMA.

Dimension associations are used when a property in one dimension is associated with the members in
another dimension.

A Plug Account from the Account dimension can be associated with the Account dimension.

The Currency dimension is associated with the Currency property of the Account dimension.

The Security Class dimension is associated with the Security Class property only in an Account and
Entity.

The Alias dimension is associated with the Alias property for Account, Entity, and Scenario dimensions.
Identify the three true statements. The EPMA import files for metadata_______.

Identify the three true statements. The EPMA import files for metadata_______.

Contains sections for Dimensions, Dimension Associations, Hierarchies, and Members

Has it that the header, file_format = ads version =1.0, is optional for the import file

Requires that all members must be declared in the Members section before they can be added to the
HIERARCHIES section

Requires the Dimensions, Dimension Associations, Hierarchies, and Members section to create a
dimension

Expects the Hierarchies section to be in Parent/Child format
How many members Lists can you load at one time?

How many members Lists can you load at one time?

1

10

2

4
Identify the three true statements about ERP Integrator (ERPI).

Identify the three true statements about ERP Integrator (ERPI).

ERPI supports PeopleSoft, Oracle E-Business Suite and SAP.

ERPI under the covers is Oracle Data Integrator.

ERPI provides drill through to BI Dashboards.

ERPI integrates metadata and data from ERP source system into an Oracle Hyperion EPM target
application.

ERPI provides drill through from Financial Management data forms, Smart View, and Financial
Reporting.
How does the FM administrator manage the Intercompany Partner dimension?

How does the FM administrator manage the Intercompany Partner dimension?

By selecting and deselecting the IsICP field on the entity member properties

Using the Dimension editor in the same way as a custom dimension or Entity dimension

It cannot be maintained by the administrator. FM automatically creates the ICP dimension to match all
members in the Account dimension.

By selecting and deselecting the IsICP field on the account member properties

It cannot be maintained by the administrator. FM automatically creates the ICP dimension to match all
members in the Entity dimension.
What are the two required steps for creating data synchronization?

What are the two required steps for creating data synchronization?

Map dimensions.

Filter dimensions

Create the synchronization.

Assign default members.

Define mappings for all members
Which utility imports users, groups, and roles into Shared Services?

Which utility imports users, groups, and roles into Shared Services?

ImportSecurity.cmd

CSSImport.cmd

UpdateUsers.cmd

ExportSecurity.cmd

ProvisionUsers.cmd
You are designing the custom dimensions for your FM application. Identify the true...

You are designing the custom dimensions for your FM application. Identify the true statement.

A dimension, once used for a specific purpose, can be used only for that purpose.

Different hierarchies within a custom dimension cannot be assigned to different accounts.

Hierarchies on custom dimensions must be symmetrical, with the same number of children under every
parent.

All hierarchies within a custom dimension are automatically available to all the accounts.

You specify the custom dimension members valid for an account by using the Custom1 Top Member,
Custom2 Top Member, Custom3 Top Member, and Custom4 Top Member.
A custom function in rules is useful for:

A custom function in rules is useful for:

Organizing rules into subsets of code

Custom functions are not possible in FM,

Defining conjunctions to be used along with variables

Controlling the ending of an If/Then

Writing code that will be repeated in multiple places
The file format load journals to FM can include which four sections?

The file format load journals to FM can include which four sections?

File Format

Standard

Scenario

Journal Group
Assuming you are using HFM Version 11.1.1.3, identify the three true statements ab...

Assuming you are using HFM Version 11.1.1.3, identify the three true statements about Calculation
Manager.

FMRulesMigrator.exe will migrate VB scripts into business rules in Calculation Manager.

To use a business rule, you must validate and deploy the business rule.

In Calculation Manager, you can create one script that can execute against both a Financial
Management application and Planning application.

There is no utility to migrate VB script rules to Calculation Manager.

In Calculation Manager, you can toggle back and forth between the graphical and script mode.
Which clearing data using the Database Management module, dimension is not include...

Which clearing data using the Database Management module, dimension is not included for selection?

Scenario

Value

Entity

Account

Custom1
In a scenario with the zero view set to year-to-date, if January is $30 year to da...

In a scenario with the zero view set to year-to-date, if January is $30 year to date and March is $90 year to
date, what value does FM calculate for February year to date if no data is loaded?

0

-30

60

30

45
Assuming you are using version 11.1.1.3, right-click menus are available in

Assuming you are using version 11.1.1.3, right-click menus are available in

Data grids only

Data grids, Data forms, and Task lists

Data grids and Data forms

Data forms only

Task lists only
You need to track and report an additional level of detail for journal entries, tr...

You need to track and report an additional level of detail for journal entries, tracking whether the adjustment
came from the GL, legal, or other source. Identify the best method to meet this requirement.

It is not possible to track additional levels of detail in journals.

Use line item details.

Use commentary to note the sources of journals.

Build a custom dimension to capture the additional level of detail.

Build subaccounts in the Accounts dimension to capture the additional level of detail.
Given the following syntax in a business rule:

Given the following syntax in a business rule:

Calculate ()

Hs.Scenario.DEFAULTVIEW ("")

DIFFERENCE

strview

Hs.Exp

Be the first to review

Take this Quiz

Quiz Info
Feb. 8, 2016, 4:45 a.m.

20 questions

12 completed

77 views

2 takers

ORACLE

Database

1Z0-532 Oracle Hyperion Financial Management 11 Essentials Exam (Exam 2) QR code

Ratings

ratings