Installing and Configuring FDQM11121

Installing and Configuring Oracle® Hyperion Financial Data Quality

Installing and Configuring Oracle® Hyperion Financial Data Quality

Management, Fusion Edition 11.1..1 for Oracle® Hyperion Financial

Management, Fusion Edition 11.1..1 for Oracle® Hyperion Financial

Management, Fusion Edition

Management, Fusion Edition

!urpose

!urpose

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

Management installation.

"ime to Complete

"ime to Complete

 Approimately 1  Approimately 1 hour.hour.

O#er#ie$

O#er#ie$

FDM is a pac!aged solution for

FDM is a pac!aged solution for finance users that includes a guided finance users that includes a guided "e#$#ased user interface for leveraging"e#$#ased user interface for leveraging standardi%ed financial data management processes& a data preparation server for

standardi%ed financial data management processes& a data preparation server for integrating and validating financialintegrating and validating financial data from any source system& and prepac!aged adapters for

data from any source system& and prepac!aged adapters for Financial Management to reduce data integration costsFinancial Management to reduce data integration costs and data$mapping compleities.

and data$mapping compleities. 'n this tutorial& you learn to

'n this tutorial& you learn to install and configure FDM& create an install and configure FDM& create an FDM application& install and configure the FinancialFDM application& install and configure the Financial Management adapters& and then lin! the

Management adapters& and then lin! the FDM application to a Financial Management application.FDM application to a Financial Management application.

%cenario

%cenario

 As an administ

 As an administrator& yrator& you are tas!ed ith iou are tas!ed ith installing FDM& nstalling FDM& creating an FDM creating an FDM application& installapplication& installing and configuring theing and configuring the Financial Management adapters& and

Financial Management adapters& and integrating the FDM integrating the FDM application ith a application ith a Financial Management application. oFinancial Management application. ouu plan on installing FDM on

plan on installing FDM on a "indos 2**+& ,-$#it system. FDM is delivered a "indos 2**+& ,-$#it system. FDM is delivered only ith 2$#it assem#lies/ hoever&only ith 2$#it assem#lies/ hoever& Financial Management and FDM can coeist on "

Financial Management and FDM can coeist on " indos 2**+ ,-$#it systems #y using 'nternet 'nformation 0ervicesindos 2**+ ,-$#it systems #y using 'nternet 'nformation 0ervices (''0) .

(''0) .

!rere&uisites

!rere&uisites

efore starting this tutorial& you should3 efore starting this tutorial& you should3

1.

1. 4ave installed and configured Foundation 0ervices and Financial Management.4ave installed and configured Foundation 0ervices and Financial Management.

 .

 . 5no the data#ase creator account and 5no the data#ase creator account and passord.passord.

' .

' . 4ave access to or have created 4ave access to or have created a Financial Management application that can lin! to a Financial Management application that can lin! to your FDM application.your FDM application.

( .

( . 5no the "indos account under hich 5no the "indos account under hich D67M o#8ects run.D67M o#8ects run.

) .

* .

* . 5no the user account in 5no the user account in your authentication directory that is used to #rose your authentication directory that is used to #rose the directory and performthe directory and perform authentication.

authentication.

+ .

+ . 4ave installed the 7racle data#ase 2$#it client& and 4ave installed the 7racle data#ase 2$#it client& and then the ,-$#it client. ou must install the clients in that order.then the ,-$#it client. ou must install the clients in that order.

Preparing for Installation

Preparing for Installation

Financial Management and FDM can coeist on "

Financial Management and FDM can coeist on " indos 2**+ ,-$#it systems #y using ''0 / hoever& you mustindos 2**+ ,-$#it systems #y using ''0 / hoever& you must ena#le ''0 , compati#ility mode #efore installing FDM.

ena#le ''0 , compati#ility mode #efore installing FDM. 'n this topic& you ena#le ''0 ,

'n this topic& you ena#le ''0 , compati#ility mode& and then you donload and compati#ility mode& and then you donload and un%ip the FDM installation files.un%ip the FDM installation files.

1.

* .

* . 5no the user account in 5no the user account in your authentication directory that is used to #rose your authentication directory that is used to #rose the directory and performthe directory and perform authentication.

authentication.

+ .

+ . 4ave installed the 7racle data#ase 2$#it client& and 4ave installed the 7racle data#ase 2$#it client& and then the ,-$#it client. ou must install the clients in that order.then the ,-$#it client. ou must install the clients in that order.

Preparing for Installation

Preparing for Installation

Financial Management and FDM can coeist on "

Financial Management and FDM can coeist on " indos 2**+ ,-$#it systems #y using ''0 / hoever& you mustindos 2**+ ,-$#it systems #y using ''0 / hoever& you must ena#le ''0 , compati#ility mode #efore installing FDM.

ena#le ''0 , compati#ility mode #efore installing FDM. 'n this topic& you ena#le ''0 ,

'n this topic& you ena#le ''0 , compati#ility mode& and then you donload and compati#ility mode& and then you donload and un%ip the FDM installation files.un%ip the FDM installation files.

1.

0erver Manager is displayed. 0erver Manager is displayed.

.

'. <ight$clic! e/ %er#er 0II%& and select dd -ole %er#ices.

+ . Donload the FDM installation files. 7n the 7racle e$Delivery site& locate 7racle 4yperion Financial Data Quality Management& Fusion :dition <elease 11.1.2.1.*& and clic! Do$nload.

4 . 0ave the 5)(+6781.9ip file to a temporary directory.

18 .

Installing Financial Data Quality Management 

'n this topic& you use :nterprise ?erformance Management (:?M) 0ystem 'nstaller to install all components of FDM.

1 . 9avigate to your 7racle :?M 0ystem installation directory and dou#le$clic! Install"ool.cmd to launch :?M 0ystem 'nstaller.

 . 7n the "elcome page of :?M 0ystem 'nstaller 11.1.2.1& verify that the installation prere@uisites have #een met& and clic! 2e3t.

( . 7n the 'nstallation Type panel& under 9e 'nstallation& select C:oose components indi#idually& and clic! 2e3t.

) . 0elect FDM& and clic! 2e3t.

2ote; 7racle 4yperion Financial Data Quality Management :<? 'ntegration Adapter for 7racle Applications& Fusion :dition (:<? 'ntegrator) is installed ith FDM.

Running EPM System Configurator for FDM 

'n this topic& you run :?M 0ystem 6onfigurator to configure FDM and :<? 'ntegrator.

1 . 0elect %tart& then !rograms& then Oracle E!M %ystem& then Foundation %er#ices& and then E!M %ystem Configurator .

:?M 0ystem 6onfigurator is displayed.

' . 7n the Tas! 0election panel& select all tas!s under FDM& and clic! 2e3t.

( . 7n the Data#ase 6onfiguration panel& perform the folloing actions3. a. 0elect !erform 1st7time configuration of data/ase.

c. 6lic! 2e3t.

) . 7n the "e#logic Domain 'nformation panel& select Deploy e/ applications to an e3isting domain & and clic! 2e3t.

The products are configured ith the settings that you specified.

4 . 7n the 0ummary panel& confirm that all configuration tas!s ere completed successfully& and clic! Finis: to close :?M 0ystem 6onfigurator.

Configuring the Web Server

'n this topic& you configure the " e# 0erver. The "e#$#ased interface provides end users and administrators access to a num#er of FDM features.

1 . 0elect %tart& then !rograms& then Oracle E!M %ystem& then Financial Data Quality Management& then e/ %er#er Components& and then e/ Config Manager .

4yperion FDM "e# 6onfig Manager is displayed.

 . :nter the user name& passord& and domain of the "indos account under hich the .9:T "e# process ill run. 2ote; This account can #e a local or a domain account& and it must have administrator rights to the "e# 0erver.

The load #alance server is the computer that stores FDM application configurations and performs load #alancing on FDM application servers. ou may also specify a #ac!up load #alance server.

) . Type iisreset to restart ''0.

Tas! Manager installs a "indos service that runs scheduled tas!s (FDM scripts) at specified intervals. ou can schedule tas!s to run repeatedly on a daily& ee!ly& or monthly #asis. The Application 0erver component ena#les the eecution of resource$intensive tas!s on a server other than the "e# server& and thus can #e used to limit data#ase and file system access to a server #ehind a fireall (hen the "e# server is in front of the fireall).

'n this topic& you assign the "  Bog on as a service"   user permission to your administrator account. This user right is

re@uired for running scheduled tas!s in Tas! Manager. ou then configure the Tas! Manager and Application Manager components.

1 . 0elect %tart& then !rograms& then dministrati#e "ools& and then <ocal %ecurity !olicy.

( . 'n the CBog on as a service ?ropertiesC dialog #o& perform these actions3

a. =erify that your administrator account is listed& or clic! dd ?ser or @roup to add your admin account. #. 6lic! O> to close the dialog #o.

) . 0elect %tart& then !rograms& then Oracle E!M %ystem& then Financial Data Quality Management& then "asA Manager & and then "asA Manager Configuration.

* . :nter the user name and passord of the "indos account under hich the Tas! Manager service and the FDM D67M o#8ects run.

2ote; The "indos account must have full control permission for the FDM application folders that reside on the data server& as ell as rights to the target system.

+ . 7n the Boad alance 0erver ta#& enter the name of your load #alance server. ou can also enter a #ac!up load #alance server.

4 . 0elect %tart& then !rograms& then Oracle E!M %ystem& then Financial Data Quality Management& then pplication %er#er & and then pplication %er#er Config Manager .

6 . :nter the user name and passord of the "indos account under hich the application server D67M o#8ects run& and clic! O>.

2ote; The "indos account must have full control permission for the FDM application folders that reside on the data server& as ell as rights to the target system.

Configuring $oa" %alance Manager 

Boad alance Manager ena#les you to #alance the load on the FDM application servers and store the FDM

application configuration. A common scenario is to install Boad alance Manager on a computer that is running the  Application 0erver component.

'n this topic& you configure Boad alance Manager #y specifying the FDM application servers to use for load #alancing.

1 . 0elect %tart& then !rograms& then Oracle E!M %ystem& then Financial Data Quality Management& then <oad =alance Manager & and then <oad =alance Configuration.

 .

 . :nter the user name and passord of the "indos account under hich the Boad alance Manager D67M o#8ects:nter the user name and passord of the "indos account under hich the Boad alance Manager D67M o#8ects run.

run. 2ote;

2ote; The "indos account must have full control permission for The "indos account must have full control permission for the FDM application folders that reside on the FDM application folders that reside on the datathe data server& as ell as rights to the target system.

' .

' . 7n the7n the pplication %er#erspplication %er#ers ta#& clic! ta#& clic! dddd& and enter the & and enter the names of all servers that run names of all servers that run the FDM Application 0erverthe FDM Application 0erver component.

( .

( . 7n the7n the ut:entication !ro#idersut:entication !ro#iders ta#& clic! ta#& clic! dd dd& and select the authentication provider that & and select the authentication provider that you ill use for FDM.you ill use for FDM. o

ou can add u can add =isual asic 0cript (=0cript)& 0ingle 0ign$on script (007 =isual asic 0cript (=0cript)& 0ingle 0ign$on script (007 script)& and 6ommon 0hared script)& and 6ommon 0hared 0ervices (600)0ervices (600) as authentication providers. 'n this tutorial& you select 0hared 0ervices (600).

) . 7n the Authentication ?rovider ta#& perform the folloing actions3 a. :nter a description for the provider.

#. :nter your 0hared 0ervices admin user name and passord. c. 6lic! "est Connection.

* . =erify that the test succeeded& and clic! O>.

2ote; 7nly accounts in the added ;<Bs can access FDM. 'f no ;<Bs are specified& the entire directory tree is searched.

Configuring Wor!bench

"or!#ench is a "indos client program that provides an administration and development environment. 't ena#les you to perform common administrator tas!s& such as creating locations& #uilding import formats& and creating validation and logic groups. 't also ena#les you to administer integration adapters& scripts& and reports. 'n this topic& you configure "or!#ench #y defining a Boad alance group.

1 . 0elect %tart& then !rograms& then Oracle E!M %ystem& then Financial Data Quality Management& then orA/enc:& and then orA/enc: Client.

' . :nter a group name and description& enter the name of your primary load #alance server& and clic! O>. 2ote; ou can also add a #ac!up server name.

 A domain name& '? address& and server name are accepta#le formats in hich to designate the server. ou can #rose for a server #y clic!ing .

Creating Financial Data Quality Management #pplications

'n this topic& you create an FDM application and data#ase. After creating the ne application& you install the standard reports and templates.

1 .

Follo the steps re@uired #y your data#ase provider to ensure that your data#ase administrator account has permission to create a ne data#ase.

 .

Bog on to FDM #y performing the folloing actions3

a. 0elect %tart& then !rograms& then Oracle E!M %ystem& then Financial Data Quality Management& then e/ %er#er Components& and then e/ <ogon.

#. 0elect B2e$ pplication& and enter the user name and passord of an account that can create FDM applications.

2ote; The specified account is added to the FDM application as an FDM administrator.

' .

7n the @eneral ta# in the 9e Application form& enter the name& description& path& and application group of the ne application.

( .

7n the Data/ase ta# perform the folloing actions3

a. 'n the 7B: D ?rovider list& select %Q<O<ED= (0QB 0erver) or O-O<ED=.O-C<E (7racle). 'n this tutorial& you select 7racle.

#. :nter the data#ase service name and the user name and passord of the FDM data#ase administrator. c. 6lic! O>.

) .

* .

9avigate to the E!MO-C<EHOMEproductsFinancialDataQuality%:aredComponents directory and open the FinancialDataManagement7-eports1111.9ip file.

This >'? contains the standard reports files for use ith 7racle or 0QB 0erver data#ases.

+ .

:tract the reports file for your data#ase to the

E!MO-C<EHOMEproductsFinancialDataQuality"estpp-eports folder. 'n this tutorial& you etract the %tandard-eportsOracle111188cti#e.3ml file.

4 .

:tract the templates file to the E!MO-C<EHOMEproductsFinancialDataQuality"estppOut/o3"emplates folder.

6 .

0elect %tart& then !rograms& then Oracle E!M %ystem& then Financial Data Quality Management& then orA/enc:& and then orA/enc: Client.

1 8 .

11 .

1  .

rose to here you un%ipped the %tandard-eportsOracle111188cti#e.3ml file& and clic! Open.

1 ' .

1 ( .

?erform the folloing actions to log on to the FDM "e# client and vie the templates.

a. 0elect %tart& then !rograms& then Oracle E!M %ystem& then Financial Data Quality Management& then e/ %er#er Components& and then e/ <ogon.

#. 0elect your application& and enter your user name and passord. c. 6lic! <ogon.

1 ) .

Installing an" Configuring Financial Management #"apters

 After creating an FDM application& you install and configure the Financial Management adapters. Financial

Management adapters ena#le interaction #eteen the FDM application and the Financial Management applications.  Adapters contain to componentsEDBB:G: and GMB metadata. DBB:G: files contain the system$specific

instructions for interacting ith target or source systems. The GMB files contain all data that relates to the current FDM application.

'n this topic& you install the Financial Management adapters and create a connection to a Financial Management application.

1 .

7n the 7racle :$Delivery site& select Oracle Hyperion Financial Data Quality Management dapter for Financial Management, Fusion Edition -elease 11.1..1.8& and clic! Do$nload.

 .

' .

:tract the 5)(41781.9ip file to E!MHOMEproductsFinancialDataQuality%:aredComponents.

( .

0elect %tart& then !rograms& then Oracle E!M %ystem& then Financial Data Quality Management& then orA/enc:& and then orA/enc: Client.

) .

* .

7n the dapters ta#& select File& then Import.

+ .

0elect FM1137@)7E.3ml& and clic! Open.

4 .

6 .

The Open Metadata Import File dialog #o is displayed.

1 8

.

11 .

2ote; FM11$H$:.ml is the standard 4FM adapter& and FM11i$H$:.ml is the 'ntercompany Detail adapter.

1 

.

1 '

.

0elect File& and then -egister dapter .

1 (

.

1 )

.

1 *

.

:nter the user name and passord of the FDM service account.

2ote3 The user name should #e the one that as used to configure the other FDM components.

+ . dd Mac:ine !rofile. 1 4 .

'n the dd Mac:ine !rofile dialog #o& enter the re@uired information3 0ource Machine is the FDM application server name.

Target Machine is the computer name or '? address of the application server or application cluster.

Optional; To override the logon method specified #y the integration settings& specify a user name& passord& and domain for the local computer.

1 6

.

?erform the folloing actions to log on to the FDM "e# client and vie the templates3

a. 0elect %tart& then !rograms& then Oracle E!M %ystem& then Financial Data Quality Management& then e/ %er#er Components& and then e/ <ogon.

#. 0elect your application& and enter your user name and passord. c. 6lic! <ogon.

 8

.

0elect dministration& and then pplication %ettings.

 1

.

 

.

0elect dministration& then Integration %ettings.

 '

.

?erform the folloing actions to set up the Financial Management application. a. 'n the 7ptions list& select pplication 2ame.

 (

.

?erform the folloing actions to set the logon method. a. 'n the 7ptions list& select <ogon Met:od.

#. 'n the Method list& select a logon method. 'n this tutorial& you select ;nified.

o ?nified; The FDM user name and passord are used to log on to the target system. For this option

to #e usa#le& the target user name and passord and the FDM user name and passord must #e the same.

o @lo/al; The user name and passord specified for glo#al logon is passed to the target system.

;sers enter the same user name and passord to connect to the target system. c. 6lic! %a#e.

 )

.

0elect cti#ities& and then Maps to test the connection to Financial Management.

 *

.

6lic! dd to add a ro.

 +

.

6lic! in the Target FM Account cell& and select =ro$se for "arget 5alue.

 4

.

ou successfully installed and configured FDM for a Financial Management application.

%ummary

'n this tutorial& you learned ho to3

• 'nstall FDM

• 6onfigure the FDM "e# 0erver& Tas! Manager& Application Manager& Boad alance Manager& and

"or!#ench

• 6reate an FDM application and install standard reports and templates

• 'nstall and configure the Financial Management adapters

-esources