Configure Work Bench Client for the Essbase adapter

Configure Work Bench Client for the Essbase adapter.

Start the ‘Work Bench Client’

Login the application you have made
 

Register the following adapters for FDqM.

• ES11X-G4-H_1006 

Select the menu ‘File – Register Adapter’ within the directoy: D:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\SharedComponents\
Select the one you want to register (ES11X-G4-H_1006)

Now import the XML file for the adapter, these are in the same directory:

 

• ES11X-G4-H_1006 

 Select ‘Select All’ and click ‘OK’   

You can see the adapter by clicking the [+]

Now we have to configure the adapters

First create a Machine profile:
right click the ‘Machine Profiles’ and choose ‘Add Machine Profile’

Source Machine : (FDM server)
Target Machine  : (Essbase server)
Click ‘OK’

Now we need to setup the adapter:

Right click the adapter and select ‘Configure’

Click the tab ‘Hyperion Essbase Intergration Setup’
Application Name  : Demo
Essbase DB Name  : Basic
Logon Method   : 2- Global

Click the tab ‘Dimentions’

Select a ‘Mapped’ Dimention and click the Target Dimension.

If the connection is okay you’ll see a pull down menu.

If the connection is not okay you’ll see the message ‘Can’t connect to ….’

Click ‘OK’

 

In note 1342362.1 ‘Unable To Connect To Essbase From Fdm Version 11.1.2.1’ we had to add some variables in the Windows System Path:
In the front:

• D:\Oracle\Middleware\EPMSystem11R1\bin; D:\Oracle\Middleware\EPMSystem11R1\bin-32

This one to the end:

• D:\Oracle\Middleware\EPMSystem11R1\products\Essbase\EssbaseClient-32\bin

Also we need to add the ESSBASEPATH in the system variables:

• ESSBASEPATH: D:\Oracle\Middleware\EPMSystem11R1\common\EssbaseRTC\11.1.2.0

To import reports we have to select menu ‘File - Import’ and goto the drectory:
D:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\SharedComponents\FinancialDataManagement-Reports11121\ ‘
Select the file ‘StandardReportsOracle1112100Active.xml’ if you are using the Oracle Database. 

 Select ‘Select All’ and click ‘OK’