OTN - Installing and Configuring FDM 11.1.1

Installing and Configuring Oracle® Hyperion Financial Data Quality Management, Fusion Edition 11.1.1.0.0 for Financial Management

Purpose

This tutorial covers installing and configuring Financial Data Quality Management (FDM) for a Financial Management installation.

Time to Complete

Approximately 2 hours.

Topics

This tutorial covers the following topics:

	Overview
	Scenario
	Prerequisites
	Installing Financial Data Quality Management
	Configuring the Web Server
	Configuring Task Manager and Application Manager
	Configuring Load Balance Manager
	Configuring Workbench
	Creating Financial Data Quality Management Applications
	Installing and Configuring the Financial Management Adapters
	Summary
	Related information

Viewing Screenshots

Place the cursor over this icon to load and view all the screenshots for this tutorial. (Caution: This action loads all screenshots simultaneously, so response time may be slow depending on your Internet connection.)

Note: Alternatively, you can place the cursor over an individual icon in the following steps to load and view only the screenshot associated with that step. You can hide an individual screenshot by clicking it.

Overview

In this tutorial, you learn to install and configure FDM, create an FDM application, and link the FDM application to a Financial Management application.

Back to Topic List

Scenario

As an administrator, you are tasked with installing FDM, creating an FDM application, and integrating the FDM application with a Financial Management application.

Back to Topic List

Prerequisites

Before starting this tutorial, you should:

1.	Have access to Workspace and Financial Management.
2.	Know the database creator account and password.
3.	Have access to or have created a Financial Management application that you can link to your FDM application.
4.	Know the Windows account under which DCOM objects run.
5.	Know the Windows account under which the .NET processes run.
6.	Know the user account in your authentication directory that is used to browse the directory and perform authentication.

Back to Topic List

Installing Financial Data Quality Management

In this topic, you install all components of FDM.

1.	Navigate to Oracle E-Delivery, and perform the following actions: a. In the Select a Product Pack drop-down list, select Oracle Enterprise Performance Management System. b. In the Platform drop-down list, select Microsoft Windows (32-bit). c. Click Go.
2.	On the Oracle Enterprise Performance Management (11.1.1.0.0) Media Pack for Microsoft Windows (32-bit) page, select Oracle Hyperion Financial Data Quality Management, Fusion Edition Release 11.1.1.0.0 Microsoft Windows X86, and click Download.
3.	Save the V13458-01.zip file to a temporary directory.
4.	Navigate to the V13458-01.zip file and extract the assembly.dat file to the assemblies folder on your computer.
5.	Navigate to your assemblies folder, and confirm that it contains the fdm folder.
6.	Navigate to your Oracle EPM System Install directory and double-click InstallTool.cmd to launch the Oracle Hyperion EPM System Installer.
7.	On the Welcome page of the Hyperion EPM System Installer Release 11.1.1, click Next.
8.	Accept the default destination folder or click Browse to enter a new destination folder, and then click Next.
9.	Select New Installation and Choose components individually, and click Next.
10.	Select FDM and click Next.
11.	Click Next to install all components.
12.	Confirm that all components are installed, and click Finish to exit Hyperion EPM System Installer Release 11.1.1.

Back to Topic List

Configuring the Web Server

In this topic, you configure the Web Server. The Web-based interface provides end users and administrators access to a number of FDM features.

1.	Select Start > Programs > Oracle EPM System > Financial Data Quality Management > Web Server Components > Web Config Manager.
2.	Enter the user name, password, and domain of the Windows account under which the .NET Web process will run. Note: This account can be a local or a domain account, and it must have administrator rights to the Web Server.
3.	On the Load Balance Server tab, enter the Load Balance server name, and click OK. The load balance server is the computer that stores FDM application configurations and performs load balancing on FDM application servers. You may also specify a backup load balance server.
4.	Select Start > Run, type cmd, and click OK to open a command prompt.
5.	Type iisreset to restart Internet Information Services (IIS).

Back to Topic

Configuring Task Manager and Application Manager

Task Manager installs a Windows service that runs scheduled tasks (FDM scripts) at specified intervals. Tasks can be scheduled to run repeatedly, daily, weekly, or monthly. The Application Server component enables the execution of resource-intensive tasks on a server other than the Web server, and thus can be used to limit database and file system access to a server behind a firewall (when the Web server is in front of the firewall).

In this topic, you assign the "Log on as a service" user permission to your administrator account. This user right is required for running scheduled tasks in Task Manager. You then configure the Task Manager and Application Manager components.

1.	Select Start > Programs > Administrative Tools > Local Security Policy, and expand Local Policies > User Rights Assignment.
2.	In the right pane, double-click Log on as a service.
3.	In the "Log on as a service Properties" dialog box, perform these actions: Verify that your admin account is listed, or click Add User or Group to add your admin account. Click OK to close the "Log on as a service Properties" dialog box. Select File > Exit to close the Local Security Policies window.
4.	Select Start > Programs > Oracle EPM System > Financial Data Quality Management > Task Manager> Task Manager Configuration.
5.	Enter the user name, password, and domain of the Windows account under which the Task Manager service and the FDM DCOM objects run. Note: The Windows account must have full control permission for the FDM application folders that reside on the data server, as well as rights to the target system.
6.	On the Load Balance Server tab, enter the name of your load balance server. You can enter a backup load balance server as well.
7.	Select Start > Programs > Oracle EPM System > Financial Data Quality Management > Application Server > Application Server Config Manager.
8.	Enter the user name, password, and domain of the Windows account under which the application server DCOM objects run, and click OK. Note: The Windows account must have full control permission on the FDM application folders that reside on the data server, as well as rights to the target system.

Back to Topic List

Configuring Load Balance Manager

Load Balance Manager enables you to balance the load on the FDM application servers and store the FDM application configuration. A common scenario is to install Load Balance Manager on a computer that is running the Application Server component.

In this topic, you configure Load Balance Manager by specifying the FDM application servers to use for load balancing.

1.	Select Start > Programs > Oracle EPM System > Financial Data Quality Management > Load Balance Manager > Load Balance Configuration.
2.	Enter the user name, password, and domain of the Windows account under which the Load Balance Manager DCOM objects run. Note: The Windows account must have full control permission on the FDM application folders that reside on the data server, as well as rights to the target system.
3.	On the Application Servers tab, click Add, and enter the names of all servers that run the FDM Application Server component.
4.	On the Authentication Providers tab, click Add, and enter the name of the authentication provider that you will use in FDM. The Authentication Provider dialog box is displayed. Note: This screen enables you to add the following authentication providers: NTLM (NT LAN Manager), LDAP (Lightweight Directory Access Protocol), MSAD (Microsoft Active Directory), VBSCRIPTSSO (Visual Basic script single sign-on), and VBSCRIPT (Visual Basic script). You can specify any combination of the five authentication providers. FDM attempts to authenticate users by using the authentication providers in the order in which they are listed, from top to bottom. You can click Move Up and Move Down to change the order. At least one enabled authentication provider is required.
5.	Enter the information for your authentication provider, and click OK. Note: When you place the cursor over an information icon (to the right of each item), a description of the item is displayed.
6.	Confirm that your authentication provider is displayed, and click OK. Note: Only accounts in the added URLs can access FDM. If no URLs are specified, the entire directory tree is searched.

Back to Topic List

Configuring Workbench

Workbench is a Windows client program that provides an administration and development environment. It enables you to perform common administrator tasks, such as creating locations, building import formats, and creating validation and logic groups. It also enables you to administer integration adapters, scripts, and reports.

In this topic, you configure Workbench by defining a Load Balance group.

1.	Select Start > Programs > Oracle EPM System > Financial Data Quality Management > Workbench > Workbench Client.
2.	In the Load Balance Server Group dialog box, click Add.
3.	Enter a group name and description, enter the name of your primary load balance server, and click OK. Note: You can also add a backup server name. A domain name, IP address, and server name are acceptable formats in which to designate the server. You can browse for a server by clicking .

Back to Topic List

Creating Financial Data Quality Management Applications

In this topic, you create an FDM application and database. After creating the new application, you install the standard reports and templates.

1.	Follow the steps required by your database provider to ensure that your database administrator account has rights to create a new database.
2.	Log on to FDM by performing the following actions: Open Internet Explorer and enter the following URL: http:///HyperionFDM/, where is the name of your Web Server. Select , and enter the user name, password, and domain of an account that can create FDM applications. Click Logon. Note: The specified account is added to the FDM application as an FDM administrator.
3.	On the General tab in the New Application form, enter the name, description, and path of the new application.
4.	On the Database tab perform the following actions: In OLE DB Provider list, select SQLOLEDB (SQL Server) or ORACLEDB.ORACLE (Oracle). Enter the database server name, database name, and the user name and password of the database administrator. Click OK.
5.	Verify that the application was created successfully, and click OK.
6.	Navigate to the V13458-01.zip file, and extract the V13458-01.zip file to a temporary directory. The file contains the Reports and Templates zipped files.
7.	Navigate to the unzipped V13458-01.zip file, and extract the FinancialDataManagement-Reports11.1.1.0.zip file to c:\Hyperion\products\FinancialDataQuality\\Reports.
8.	Navigate to the unzipped V13458-01.zip file, and extract the FinancialDataManagement-Templates11.1.1.0.zip file to c:\Hyperion\products\FinancialDataQuality\\Outbox\Templates.
9.	Select Start > Programs > Oracle EPM System > Financial Data Quality Management > Workbench > Workbench Client.
10.	Select your application, enter the user name, password, and domain (if necessary), and click OK.
11.	Select the Report tab, and then select File > Import.
12.	Select the file c:\hyperion\fdm\\Reports\StandardReportsSQLServer1111Active.xml (for SQL) or c:\hyperion\fdm\\Reports\StandardReportsOracle1111Active.xml (for Oracle), and click Open.
13.	On the General tab, select Reports and click OK.
14.	Select File > Exit.
15.	Log on to your application by performing the following actions: In Internet Explorer, enter the following URL: http:///HyperionFDM/, where is the name of your name of your Web server. Select your application, and enter the user name, password, and domain (if necessary). Click Logon.
16.	In the navigation pane, select Tools > Templates to view the imported templates.

Back to Topic List

Installing and Configuring Financial Management Adapters

After you create an FDM application, you install and configure the Financial Management adapters. Financial Management adapters enable interaction between the FDM application and the Financial Management applications.

Adapters have two components —DLL/EXE and XML metadata. DLL/EXE files contain the system-specific instructions for interacting with target or source systems. XML files contain all data that relates to the current FDM application.

In this topic, you install the Financial Management adapters and create a connection to a Financial Management application.

1.	On the Oracle E-Delivery site, select Oracle Hyperion Financial Data Quality Management Adapter for Financial Management, Fusion Edition Release 11.1.1.0.0 Microsoft Windows X86, and click Download.
2.	Save the V13502-01.zip file to a temporary directory.
3.	Extract the V13502-01.zipfile to c:\Hyperion\products\FinancialDataQuality\SharedComponents.
4.	Select Start > Programs > Oracle EPM System > Financial Data Quality Management > Workbench > Workbench Client.
5.	Select your application, enter the user name, password, and domain (if necessary), and click OK.
6.	On the Adapters tab, select File > Import.
7.	Select FM9x-G4-B.xml, and click Open.
8.	On the General tab, select Integration Adapters, and click OK.
9.	On the Oracle Hyperion FDM Workbench, select File > Import.
10.	Select FM9i-G4-B.xml, and click Open.
11.	Select Integration Adapters, and click OK. Note: FM9x-G4-B.xml is the standard HFM adapter, and FM9i-G4-B.xml is the Intercompany Detail adapter.
12.	Verify that the two adapters are displayed in the Target System Adapters section on the Adapters tab.
13.	Select File > Register Adapter.
14.	Select upsFM9xG4B.dll, and click Open.
15.	Verify that the adapter registered successfully, and click OK.
16.	In the navigation pane, expand Target System Adapters > FM9x-G4-B.xml, right-click Machine Profile, and select Add Machine Profile.
17.	In the Add Machine Profile dialog box, enter the required information: Source Machine is the FDM application server name. Target Machine is the computer name or IP address of the application server or application cluster. Optional: To override the logon method specified by the integration settings, specify a user name, password, and domain for the local computer
18.	In the navigation pane, expand Target System Adapters > FM9i-G4-B.xml, right-click Machine Profile, and select Add Machine Profile.
19.	In the Add Machine Profile dialog box, enter the required information: Source Machine is the FDM application server name. Target Machine is the computer name or IP address of the application server or application cluster. Optional: To override the logon method specified by the integration settings, specify a user name, password, and domain for the local computer.
20.	Log on to your application by performing the following actions: In Internet Explorer, enter http:///HyperionFDM/, where is the name of your Web server. Select your application and enter the user name, password, and domain (if necessary). Click Logon.
21.	Select Administration > Application Settings.
22.	In the System Code list, select FM9X-G4-B, and click Save.
23.	Select Administration > Integration Settings.
24.	In Integration Settings, perform the following actions: In the Options list, select Application name. In the App Name box, enter the name of your Financial Management application.
25.	In Integration Settings, perform these actions: In the Options list, select Logon Method. In the Method list, select a logon method: Unified: The FDM user name and password are used to log on to the target system. For this option to be usable, the target user name and password and the FDM user name and password must be the same. Global: The user name and password specified for global logon is passed to the target system. Users enter the same user name and password to connect to the target system. Click Save.
26.	Select Activities > Maps to test the connection to Financial Management.
27.	Click Add to add a row.
28.	Click in the Target FM Account cell, and select Browse for Target Value.
29.	Verify that the list of accounts is from your Financial Management application. You have successfully installed and configured FDM for a Financial Management application.

Back to Topic List

Summary

In this tutorial, you learned how to:

	Install Financial Data Quality Management
	Configure the FDM Web Server, Task Manager, Application Manager, Load Balance Manager, and Workbench
	Create an FDM application and install standard reports and templates
	Install and configure the Financial Management adapters

Back to Topic List

Related Information

To learn more about Financial Data Quality Management, refer to additional OBEs on the OTN Web site