Oracle® Hyperion Financial Management, Fusion Edition

Administrative Transition Guide

Release 11.1.2.1

Authors: EPM Information Development Team

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited. The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this software or related documentation is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:

U.S. GOVERNMENT RIGHTS: Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, duplication, disclosure, modification, and adaptation shall be subject to the restrictions and license terms set forth in the applicable Government contract, and, to the extent applicable by the terms of the Government contract, the additional rights set forth in FAR 52.227-19, Commercial Computer Software License (December 2007). Oracle USA, Inc., 500 Oracle Parkway, Redwood City, CA 94065.

This software is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications which may create a risk of personal injury. If you use this software in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure the safe use of this software. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software in dangerous applications.

Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

This software and documentation may provide access to or information on content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.

Table of Contents:

About Using Performance Management Architect Modules

Financial Data Management

Summary of Changes to Key Financial Management Administration Tasks

Summary of Classic Application Administration Tasks

Oracle Hyperion EPM Architect, Fusion Edition is a feature in Oracle Hyperion Financial Management, Fusion Edition that enables administrators to manage, create, and deploy applications within one interface.

This document describes the key changes to administration features introduced with Performance Management Architect. It also includes information on Classic Application Administration features for any application not being managed using Performance Management Architect.

About Using Performance Management Architect Modules

Performance Management Architect has the following modules:

Dimension Library—A centralized location to manage dimensions and dimension properties. You can use the Dimension Library to:
- Create dimension import profiles—enabling dimension updates from flat files and relational database interface tables
- Add, delete, and modify dimension members in the Shared Library or directly in applications
- Modify dimension and member properties in the Shared Library or directly in applications
Application Library—A summary of applications that have been created and/or deployed to Financial Management, Oracle Hyperion Planning, Fusion Edition, Oracle Hyperion Profitability and Cost Management, Fusion Edition, Essbase Aggregate Storage Option (ASO), or Essbase Block Storage Option (BSO). Applications contain dimensions and dimension attributes that are designed to meet specific requirements for Financial Management, Planning, Profitability and Cost Management, and Essbase (ASO) and (BSO) needs. You can use the Application Library to:
- Create Financial Management, Planning, Profitability and Cost Management, Essbase (ASO), or Essbase (BSO) applications based on Financial Management, Planning, and Profitability and Cost Management applications
- Manage applications in one centralized location
- View the data flow between applications
- Migrate applications to different servers as long as the servers are registered in the same Oracle's Hyperion® Shared Services instance
- Deploy applications to Financial Management, Planning, Profitability and Cost Management, Essbase (ASO), or Essbase (BSO)
Calculation Manager—Enables you to create, validate, and deploy business rules and business rule sets.
There are three types of objects that can be calculated in Hyperion Calculation Manager:
- Components, which are objects that comprise business rules and can contain formulas, scripts, conditions, ranges, fixed loops, and allocations.
- Rules, which are objects that contain groups of components that perform calculations
- Rule Sets, which are objects that contain two or more rules that are calculated simultaneously or sequentially.
  If you are using a Financial Management, Planning, or Oracle Essbase block storage application, you can include Hyperion Calculation Manager system templates in business rules. For example, you can use a system template that copies data from one location to another. You can also create custom defined templates to perform calculations that solve problems unique to your business.
Data Synchronization—Enables data synchronization between or within Hyperion applications. You can use the Data Synchronizer to:
- Create data synchronizations between Financial Management, Planning, Profitability and Cost Management, Essbase (ASO), and Essbase (BSO) as destinations, and the following sources:
  - Financial Management
  - Planning
  - Oracle Hyperion Profitability and Cost Management, Fusion Edition
  - Essbase BSO
  - Essbase ASO
  - External source (flat file)
  - Interface table
    For example, an administrator can synchronize data between two Financial Management applications; 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
Application Upgrade—Enables upgrades from Classic Financial Management, Planning, and Essbase applications to Performance Management Architect
Library Job Console—Provides a summary, including status, of Dimension Library and application activities, including imports, deployments, and data synchronizations

Financial Data Management

You can load data from E-Business Suite or PeopleSoft source systems into Financial Management using Oracle Hyperion Financial Data Quality Management ERP Integration Adapter for Oracle Applications through:

Financial Management Classic Administration
Performance Management Architect
Oracle Hyperion Financial Data Quality Management, Fusion Edition

ERP Integrator is a module of Oracle Hyperion Financial Data Quality Management, Fusion Edition that enables you to:

Integrate metadata and data from an Enterprise Resource Planning (ERP) source system into an Oracle Hyperion EPM target application.
Drill through from the EPM application (Financial Management or Planning through web forms, Oracle Hyperion Smart View for Office, Fusion Edition or Oracle Hyperion Financial Reporting, Fusion Edition) and view details in the ERP source system.
Write back budget data to the source system from any Oracle Hyperion Planning, Fusion Edition, Essbase ASO, or Oracle Essbase BSO application.

ERP Integrator supports general ledger data for:

PeopleSoft Enterprise Financial Management 9.0
Oracle E-Business Suite 11.5.10
Oracle E-Business Suite 12.0
Oracle E-Business Suite 12.1

ERP Integrator supports human resources data for:

PeopleSoft Human Capital Management 9.0

For information on Oracle Hyperion Financial Data Quality Management ERP Integration Adapter for Oracle Applications, see the Oracle Hyperion Financial Data Quality Management ERP Integration Adapter for Oracle Applications Administrator's Guide.

Summary of Changes to Key Financial Management Administration Tasks

Table 1. Changes to Key Tasks in Financial Management

Category / Action	Classic Action	Performance Management Architect Action
Application Creation and Application Management
Profile creation	Use the Win 32 Client to create Application profiles. These templates define the languages, calendar, frequencies and periods for applications.	Import dimensions into the Dimension Library using an import profile. You can utilize these profiles to populate the Dimension Library from flat files or relational interface tables. Profiles define the mapping of the dimensional information within the flat file or interface table. The languages, calendar, frequencies, and periods are now treated as dimensions similar to other dimensions (accounts, entities, and so on). Similar to earlier versions, these dimensions cannot be altered once an application has been created.
Application	In the Web or Win 32 Client, select Create Application, then enter the application label, description, and select the application profile.	Select File, New, Application. Follow the steps in the Application Wizard to create the application. After you create the application in Performance Management Architect, you must deploy the application to Financial Management. After deployment, the application is available in Financial Management.
Application settings	In the Web or Win 32 Client, select Manage Metadata. Open the application file and select AppSettings.	Open the application and click on the application name. The application settings are displayed in the Property Grid.
Creating dimensions	In the Win 32 Client, select Manage Metadata. Then, open the application file and select the dimension to edit.	Open the Dimension Library. (Navigate, Administer, Dimension Library) Perform one of these actions: Import dimensions into the Dimension Library by creating and importing a flat file or importing information from interface tables. (File, Import, Create Profile) Select File, New, Dimension. Enter a name, description and select the dimension type.
Modifying properties in bulk	Use the List view in Metadata Management.	Right-click a dimension and select Grid Editor. Select the members you want to edit in the Grid Editor wizard, then click Next. Then, select the properties and click Finish. In the Grid Editor, modify the properties and members, as necessary.
Searching for members	Use Find in the Metadata Manager.	Right-click a dimension and click Find Members. Select to search by the member: Name, Alias, or Property. Click OK.
Reordering child members	Use the Up and Down arrows to reorder members within the Metadata Manager.	You can reorder children in the Dimension Library. Drag a member up or down to change the order or right-click the dimension where you want to reorder the children, then, select Reorder Children. Change the order of the children and click OK.
Metadata editing	In the Win 32 Client, open the application. Perform one of these actions: Save the Application files and load into the Financial Management application from the Web or Win 32 Client. Make the modifications directly within the XML or APP files and load into the Financial Management application.	Perform one of these actions: Edit dimensions in the Dimension Library. Edit dimensions in the *.ads flat files. Then, reload into the Dimension Library in replace or merge mode; or load the modified dimensions through the interface tables within the profile.
Metadata flat file formats	Hyperion Application files (.app) and XML files (.xml)	Financial Management utilizes a new flat file format, (.ads). Existing Financial Management .xml files can be converted into the new *.ads file format using the Performance Management Architect File Generator utility. You can install the File Generator utility as a component of Performance Management Architect when using the Oracle Hyperion Enterprise Performance Management System Installer, Fusion Edition.
Application upgrade	Run HFM Schema Upgrade.exe to modify the existing application’s database and register the applications with Shared Services.	Run HFM Schema Upgrade.exe to modify the existing application’s database and register the applications with Shared Services. Bring the upgraded applications into the Application Library: Select Navigate, Administer, Application Upgrade. Navigate through the Application Upgrade wizard, selecting the applications to be brought into the Application Library.
Duplicating applications within the same environment	Application artifacts can be exported into flat files from either the Web or Win 32 Client: Application Profile Security Metadata Member Lists Rules Data Journals Documents A replica of the application can then be created by utilizing these artifacts within a new application.	Select Navigate, Administer, Application Library. Right-click the source application and select Duplicate, As New Application. Enter a new name, select the application type, and input a description. The new application contains the same application settings and dimensionality as the original application. Deploy the new application and load the existing application artifacts into the new application.
Duplicating applications to a new instance	Run HfmCopyApplication.exe. Then, populate the dialog box with the appropriate source and target application information.	Duplicating applications to a new instance in Performance Management Architect, duplicates only artifacts and does not include transaction data. If the application does not exist in the destination: Use the Financial Management Copy Application Utility to copy the Financial Management application. After you have completed the copy application, upgrade the destination application to Performance Management Architect. If the application exists in the destination: Use the Financial Management Copy Application Utility to copy the Financial Management application. Use Oracle Hyperion Enterprise Performance Management System Lifecycle Management to copy Performance Management Architect artifacts. Redeploy the application in the destination environment.
Replicating applications from its artifacts	You can export these application artifacts into flat files from the Web or Win 32 Client: Security Metadata Member Lists Rules Data Journals Documents A replica of the application can then be created by utilizing these artifacts within a new application.	Applications can be extracted utilizing the Performance Management Architect File Generator utility. This utility creates an .ads flat file containing the application settings and the dimensional structures for the selected application. A replica of the application can then be created by combining the .ads file with the following artifacts (which can be extracted from the Financial Management Web or Win 32 Client): Security Member lists Rules Data Journals Documents
Deleting applications	In the Win 32 Client, select Delete Application. Then, select the application from the server cluster and click Delete Application.	Open the Application Library, right-click on the source application and select Delete. Then, confirm the deletion of the application. The application is deleted from the Application Server and the application is removed from the Application Library.
Data Synchronization
Copying data between applications	Data can be copied through extract and load using either the Win 32 or Web Client.	Open the Data Synchronization module (Navigate, Administer, Data Synchronization) then select File, New, Synchronization. Follow the wizard to define source and target information. After you select the source and target, define the appropriate dimension mappings, apply filters, and save the synchronization. You can execute the synchronization manually or schedule an automated task using Task Automation.
Loading data into applications	Data can be loaded using the Load Data option using either the Win 32 or Web Client. You can also use Hyperion Financial Data Quality Management.	In Financial Management you have the ability to load data, within the same Shared Services environment, using the interface tables included with the Data Synchronization module. Open the Data Synchronization module (Navigate, Administer, Data Synchronization) then select File, New, Synchronization. Follow the wizard to define source and target information. For the source information, select Hyperion Data Interface Area (for data loaded via relational database) or External Source (for data loaded via flat files). For the target information, select the appropriate Financial Management application. You can predefine external files and data interface information using File, New, Data Interface Table Definition or File, New, External File Definition prior to building the synchronization. You can manually execute the synchronization or schedule the synchronization using Task Automation.
Security
Classic Editor	Using the Financial Management Configuration Utility, assign the Application Creator role.	Assign the Application Creator role using the Shared Services Global role listing. Note: If you are using Performance Management Architect, you need the global role to create/deploy applications. The Application Creator role from the Financial Management Configuration Utility is not needed.
Create Applications Role	Applications could be created by any user that has been provisioned as an Administrator through Shared Services for the given application.	The Performance Management Architect Shared Services role of Application Creator by product allows the user to create and deploy applications.
Dimension Editing Role	Dimension editing can be performed by any user that has been provisioned as an Administrator through Shared Services for the given application.	The Dimension Editor for Oracle Hyperion EPM Architect, Fusion Edition allows the user to create, manage, delete, and assign dimension security to other users.
Calculation Manager Administrator	Rules files are maintained using the Financial Management Rules Editor.	Financial Management Calculation Manager Administrator enables you to create business rules using Calculation Manager.
Dimension Security	Dimension modifications can only be made by users that have been provisioned as Administrators through Shared Services for the given application.	Dimension security is assigned by the Dimension Editor or the Dimension Owner.

Summary of Classic Application Administration Tasks

Table 2. Classic Application Administration Tasks

Category / Action	Classic Action	Oracle Enterprise Performance Management Workspace, Fusion Edition Action
Application Creation and Application Management
Create applications on the Web	Log on Financial Management at http://servername/HFM/. Select File, Create Application. Populate the required application information and select Create.	Log on EPM Workspace. Select Navigate, Administer, Classic Application Administration, Consolidations Administration. Select Create Application. Populate the application information and select Create.
Open applications on the Web	Select File, Open Application. Select the application from the server cluster.	Select Navigate, Applications, Consolidation, Refresh. The new application is added to the existing list.
Delete applications on the Web	Log on Financial Management at http://servername/HFM/. Select File, Delete Application. Select the application from the server cluster, then click OK.	Log on Oracle Enterprise Performance Management Workspace, Fusion Edition. Select Navigate, Administer, Classic Application Administration, Consolidations Administration. Select Delete Application. Select the application from the server cluster and click OK.
Register applications on the Web	Log on Financial Management at http://servername/HFM/. Select File, Register Application. Select the application from the server cluster. Review the application information and click Register.	Select Administration, Consolidations Administration. Select Register Application. Select the application from the server cluster. Review the application information and click Register.
Security
Application Creation	To create applications, you must be a member of the Application Creators group designated within the Financial Management Server and Web configuration.	To create applications, you must be a member of the Application Creators group designated within the Oracle Hyperion Financial Management, Fusion Edition Server and Web configuration. In addition, in Oracle's Hyperion® Shared Services, you must be assigned the Dimension Editor and Financial Management Application Creator roles.