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

Have installed and configured Foundation Services and Financial Management.

Know the database creator account and password.

Have access to or have created a Financial Management application that can link to your FDM application.

Know the Windows account under which DCOM objects run.

Know the Windows account under which the .NET processes run.

Know the user account in your authentication directory that is used to browse the directory and perform authentication.

Have installed the Oracle database 32-bit client, and then the 64-bit client. You must install the clients in that order.

Select Start, then Administrative Tools, and then Server Manager.

Server Manager is displayed.

Under your server name, expand Roles.

Right-click Web Server (IIS), and select Add Role Services.

Select IIS 6 Management Compatibility, and click Next.

Review the confirmation message, and click Install.

Verify that the installation was completed successfully, and click Close.

Download the FDM installation files. On the Oracle e-Delivery site, locate Oracle Hyperion Financial Data Quality Management, Fusion Edition Release 11.1.2.1.0, and click Download.

Save the V25479-01.zip file to a temporary directory.

Extract the ZIP file to the location where your installation files are stored.

Navigate to the assemblies folder where your installation files are stored, and confirm that it contains the fdm folder.

Navigate to your Oracle EPM System installation directory and double-click InstallTool.cmd to launch EPM System Installer.

On the Welcome page of EPM System Installer 11.1.2.1, verify that the installation prerequisites have been met, and click Next.

Accept the existing Middleware Home directory, and click Next.

On the Installation Type panel, under New Installation, select Choose components individually, and click Next.

Select FDM, and click Next.

Note: Oracle® Hyperion Financial Data Quality Management ERP Integration Adapter for Oracle Applications, Fusion Edition (ERP Integrator) is installed with FDM.

On the Confirmation panel, review the components to be installed, and click Next to begin the installation.

Confirm that all components of FDM were installed successfully, and click Finish to close EPM System Installer.

Select Start, then Programs, then Oracle EPM System, then Foundation Services, and then EPM System Configurator.

EPM System Configurator is displayed.

On the Oracle Instance panel, select Modify an existing EPM Oracle instance, and click Next.

On the Task Selection panel, select all tasks under FDM, and click Next.

On the Database Configuration panel, perform the following actions:.

1. Select Perform 1st-time configuration of database.
2. Enter the database connection details for the ERP Integrator database.
3. Click Next.

On the Weblogic Domain Information panel, select Deploy Web applications to an existing domain, and click Next.

On the Oracle WebLogic panel, accept the default values, and click Next.

On the Confirmation panel, review the configuration tasks to be performed, and click Next.

The products are configured with the settings that you specified.

On the Summary panel, confirm that all configuration tasks were completed successfully, and click Finish to close EPM System Configurator.

Select Start, then Programs, then Oracle EPM System, then Financial Data Quality Management, then Web Server Components, and then Web Config Manager.

Hyperion FDM Web Config Manager is displayed.

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.

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.

Select Start, and then Run, type cmd, and click OK to open a command prompt.

Type iisreset to restart IIS.

Select Start, then Programs, then Administrative Tools, and then Local Security Policy.

Expand Local Policies, and then User Rights Assignment.

In the right pane, double-click Log on as a service.

In the "Log on as a service Properties" dialog box, perform these actions:

1. Verify that your administrator account is listed, or click Add User or Group to add your admin account.
2. Click OK to close the dialog box.
3. Select File, and then Exit to close the Local Security Policies window.

Select Start, then Programs, then Oracle EPM System, then Financial Data Quality Management, then Task Manager, and then Task Manager Configuration.

Enter the user name and password 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.

On the Load Balance Server tab, enter the name of your load balance server. You can also enter a backup load balance server.

Select Start, then Programs, then Oracle EPM System, then Financial Data Quality Management, then Application Server, and then Application Server Config Manager.

Enter the user name and password of the Windows account under which the application server DCOM objects run, and click OK.

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.

Select Start, then Programs, then Oracle EPM System, then Financial Data Quality Management, then Load Balance Manager, and then Load Balance Configuration.

Enter the user name and password of the Windows account under which the Load Balance Manager 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.

On the Application Servers tab, click Add, and enter the names of all servers that run the FDM Application Server component.

On the Authentication Providers tab, click Add, and select the authentication provider that you will use for FDM. You can add Visual Basic Script (VBScript), Single Sign-on script (SSO script), and Common Shared Services (CSS) as authentication providers. In this tutorial, you select Shared Services (CSS).

On the Authentication Provider tab, perform the following actions:

1. Enter a description for the provider.
2. Enter your Shared Services admin user name and password.
3. Click Test Connection.

Verify that the test succeeded, and click OK.

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.

Select Start, then Programs, then Oracle EPM System, then Financial Data Quality Management, then Workbench, and then Workbench Client.

In the Load Balance Server Group dialog box, click Add.

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 .

Follow the steps required by your database provider to ensure that your database administrator account has permission to create a new database.

Log on to FDM by performing the following actions:

1. Select Start, then Programs, then Oracle EPM System, then Financial Data Quality Management, then Web Server Components, and then Web Logon.
2. Select <New Application>, and enter the user name and password of an account that can create FDM applications.
3. Click Logon.

Note: The specified account is added to the FDM application as an FDM administrator.

On the General tab in the New Application form, enter the name, description, path, and application group of the new application.

On the Database tab perform the following actions:

1. In the OLE DB Provider list, select SQLOLEDB (SQL Server) or ORAOLEDB.ORACLE (Oracle). In this tutorial, you select Oracle.
2. Enter the database service name and the user name and password of the FDM database administrator.
3. Click OK.

Verify that the application was created successfully, and click OK.

Navigate to the EPM_ORACLE_HOME/products/FinancialDataQuality/SharedComponents directory and open the FinancialDataManagement-Reports11121.zip file.

This ZIP contains the standard reports files for use with Oracle or SQL Server databases.

Extract the reports file for your database to the EPM_ORACLE_HOME/products/FinancialDataQuality/TestApp/Reports folder. In this tutorial, you extract the StandardReportsOracle1112100Active.xml file.

Extract the templates file to the EPM_ORACLE_HOME/products/FinancialDataQuality/TestApp/Outbox/Templates folder.

Select Start, then Programs, then Oracle EPM System, then Financial Data Quality Management, then Workbench, and then Workbench Client.

Select your application, enter the user name and password, and click OK.

Select the Report tab, and then select File, and then Import.

Browse to where you unzipped the StandardReportsOracle1112100Active.xml file, and click Open.

On the General tab, select Reports and click OK.

Perform the following actions to log on to the FDM Web client and view the templates.

1. Select Start, then Programs, then Oracle EPM System, then Financial Data Quality Management, then Web Server Components, and then Web Logon.
2. Select your application, and enter your user name and password.
3. Click Logon.

In the navigation pane, select Tools, and then Templates to view the imported templates.

On the Oracle E-Delivery site, select Oracle Hyperion Financial Data Quality Management Adapter for Financial Management, Fusion Edition Release 11.1.2.1.0, and click Download.

Save the V25481-01.zip file to a temporary directory.

Extract the V25481-01.zip file to EPM_HOME\products\FinancialDataQuality\SharedComponents.

Select Start, then Programs, then Oracle EPM System, then Financial Data Quality Management, then Workbench, and then Workbench Client.

Select your application, enter the user name and password, and click OK.

On the Adapters tab, select File, then Import.

The Open Metadata Import File dialog box is displayed.

Select FM11x-G5-E.xml, and click Open.

On the General tab, select Integration Adapters, and click OK.

On the Adapters tab, select File, then Import.

The Open Metadata Import File dialog box is displayed.

Select FM11i-G5-E.xml, and click Open.

On the General tab, select Integration Adapters, and click OK.

Note: FM11x-G5-E.xml is the standard HFM adapter, and FM11i-G5-E.xml is the Intercompany Detail adapter.

Verify that the two adapters are displayed under Target System Adapters.

Select File, and then Register Adapter.

Select fdmFM11XG5E.dll, and click Open.

Right-click FM11X-G5-E, and select Configure to configure the adapter.

Enter the user name and password of the FDM service account.

Note: The user name should be the one that was used to configure the other FDM components.

In the navigation pane, expand Target System Adapters, then FM11x-G5-E, right-click Machine Profile, and select Add Machine Profile.

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.

Perform the following actions to log on to the FDM Web client and view the templates:

1. Select Start, then Programs, then Oracle EPM System, then Financial Data Quality Management, then Web Server Components, and then Web Logon.
2. Select your application, and enter your user name and password.
3. Click Logon.

Select Administration, and then Application Settings.

In the System Code list, select FM11X-G5-E, and click Save.

Select Administration, then Integration Settings.

Perform the following actions to set up the Financial Management application.

1. In the Options list, select Application Name.
2. In the App Name box, enter the name of your Financial Management application.

Perform the following actions to set the logon method.

1. In the Options list, select Logon Method.
2. In the Method list, select a logon method. In this tutorial, you select Unified.
   • 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.
3. Click Save.

Select Activities, and then Maps to test the connection to Financial Management.

Click Add to add a row.

Click in the Target FM Account cell, and select Browse for Target Value.

Verify that the list of accounts is from your Financial Management application.

You successfully installed and configured FDM for a Financial Management application.