Correct Answer: B

To set up the calendar:

1.In the Classic Application Wizard, click Calendar.

2 Select a Base Period option to set how calendars roll up:

*12 Months: Four quarters per year; months roll up into parent quarters and quarters into years.

*Quarters: Quarters roll up into years.

* Custom: A custom time period, such as weeks or days. Etc.

Note: The calendar establishes the application's base time periods, starting fiscal year and month, and total number of years. Select the base time period and monthly distribution pattern based on the number of fiscal weeks in a month. The base time period options are the bottom-level time periods in the application. You can create a custom base time period, such as weeks or days. Use monthly distribution patterns to determine how data entered into a summary time period is distributed or spread among the base time period you select. During data entry, users can enter data into summary time periods, such as years or quarters. Planning distributes these values over the base time periods that constitute the summary time period.

Reference: Oracle Hyperion Planning, Fusion Edition, Setting up the Calendar

Correct Answer: AE

A: To develop a calculation script that exports a subset of data, you first specify the SET DATAEXPORTOPTIONS command to define options for export content, format, and process Use FIX...ENDFIX or EXCLUDE...ENDEXCLUDE calculations to select a slice of the database and use a DATAEXPORTCOND command to select data based on data values.

Note: The DATAEXPORT command enables calculation scripts to export data in binary or text, or directly to a relational database. A set of data-export-related calculation commands qualify what data to export and provide various output and

formatting options.

Compared to using other methods to export data, using a calculation script has the following advantages and disadvantages:

Advantages:

Enables exporting a subset of data.

*

Supports multiple targets: flat files, relational databases, and binary files (not B, C, D)

*

Provides many flexible options for type and format or data.

*

As part of a calculation script, can be easily deployed in a batch process.

*

Can be very fast when the dynamic calculation export option is not used because DATAEXPORT directly accesses Kernel storage blocks in memory. (E)

*

Provides, through binary export-import, a faster way to back up and restore data because the compressed format used by binary export requires less storage for the export files.

*

Can be used as a debug tool to trace batch calculation results by using the DATAEXPORT command before and after other calculation commands to track data changes.

Disadvantages

Contains limited data formatting options compared to Report Writer formatting.

Correct Answer: ABCEF

A: Essbase data load rules: A set of criteria that determines how to load data from a text-based file, a spreadsheet, or a relational data set into a database.

You can use either the Data Load Rules and the Essbase Administration Services for Essbase 7/Analytic Administration Services for Analytic Services 9.2 or Hyperion Application Link with the Hyperion Essbase Adapter to load data into a

Planning application.

B: Oracle Data Integrator (ODI) is a comprehensive data integration platform that handles any data integration requirements--high-volume, high-performance batches, event-driven, trickle-feed integration processes, and SOA-enabled data

services.

C: One of the methods of loading Essbase cubes is by using the Hyperion Data Integration Management and its corresponding Essbase Adapter.

Data Integration Management is integrated with Informatica PowerCenter. It provides a way of uniting disparate sources of data across an enterprise. For example, it can integrate data stored in multiple warehouses and data marts, relational

database management systems (RDBMS), and on-line analytical processing (OLAP) stores.

E: The Outline Load Utility that comes with Oracle EPM 11 is a utility for loading the metadata as well as data into your Planning applications. Using the utility we can load metadata for the default dimensions like Account, Period, Year, Scenario, Version, Currency, Entity as well as user-defined dimensions, attributes and UDAs.

F: Enterprise Performance Management Architect or EPMA provides a uniform platform for metadata management across most of the Hyperion components. It enables administrators to manage, create, and deploy Hyperion applications within one interface. With EPMA you can configure dimensions, such as the Entity, and define properties from predefined, sample libraries.

Correct Answer: C

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.

Correct Answer: C

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.

Correct Answer: BD

B: Calculation Manager, a component of Hyperion Enterprise Performance

Management Architect, is the new tool to create business rules and business rule sets to run against Hyperion Planning and Oracle Essbase.

D: EPMA Data Synchronization--Enables data synchronization within Hyperion applications. You can use the Data Synchronizer to:

*Create data movement synchronizations between Hyperion applications. For example, an administrator can synchronize data between two Financial Management; two Planning

applications, and between one Financial Management and a Planning application

*Create data mappings for reuse *Create flat file and interface table mappings to import data into Hyperion applications

Note:

Correct Answer: DE

D: The planning Calculation Manager Administrator enables you to create business rules using Hyperion Calculation Manager.

E: The global Shared Services role of Dimension Editor creates and manages dimensions.

The global Calculation Manager administrator role enables you to create, edit and delete Planning, FinancialManagement, and Essbase objects. The Financial Management Calculation Manager administrator role enables to create, edit and delete Financial Management objects.

Correct Answer: ABCDFG

Incorrect answer:

With a smart list you can only select from pre-defined options in a list-

Correct Answer: D

First calculate the aggregated saleries.

Then make the custom calculation on the saleries.

Finally use the result of the custom calculation to product the benefits.

Correct Answer: ACE

A: Business Rules can be assigned to data forms.

C: You can manage database locations, and the access privileges of repository objects that are assigned to them, using the Location Editor. You can use the Location Editor to create, edit, and copy database locations, assign new access privileges to locations, copy access privileges from one location to another, and copy business rules from one location to another.

E: When you validate a business rule, Business Rules determines whether the member or members you select exist in the database and whether the syntax of the business rule is correct. You need to have access privileges to all rules in the sequence before you can launch it.

Reference: Hyperion Business Rules, Administrative Guide, Release 9.3.1