FDM-Essbase Adapter Issue in Hyperion 11.1.2.x

Hyperion FDM – Essbase Adapter issue:Connection failed

1. We need to install Essbase Client on the FDM server.
2. We need to update the path Environment variable
   C:\Oracle\Middleware\EPMSystem11R1\bin-32;C:\Oracle\Middleware\EPMSystem11R1\common\EssbaseRTC\11.1.2.0\bin;C:\Oracle\Middleware\EPMSystem11R1\Products\Essbase\EssbaseClient-32\bin;(Ensure this is in single line)
3. Check ARBORPATH and ESSBASEPATH in the Environmental variables.

ARBORPATH: C:\Oracle\Middleware\EPMSystem11R1\common\EssbaseRTC\11.1.2.0
ESSBASEPATH: C:\Oracle\Middleware\EPMSystem11R1\common\EssbaseRTC\11.1.2.0

Extract files to here: 

ES11x-G4-K:C:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\SharedComponents

upsEX11xG4K:C:\Oracle\Middleware\EPMSystem11R1\common\EssbaseRTC\11.1.2.0\bin

Now Goto FDM --> Import

Go to this path

          C:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\SharedComponents

Register Adapter

File --> Register Adapter

Go to this path

C:\Oracle\Middleware\EPMSystem11R1\common\EssbaseRTC\11.1.2.0\bin

                                         In the Second Tab: Hyperion Essbase Integration Setup;

                               Enter Essbase application and database name and select Logon Method 

Now In the Dimensions Tab, you can see Target Essbase application Dimensions as shwon below

                                                                                                                  

Thanks,

Mady