Problem: When attempting load data to Essbase or browsing for target values in the mapping table, the process returns the error message: Error: Export failed. Detail: File not found: esbapin.DLL
Cause: FDM Essbase adapter .exe cannot locate esbapin.dll, which is part of the Essbase API.
Detail: esbapin.dll is a file of the Essbase client API that FDM uses to connect to Essbase. It is located in the Essbase home\Bin directory in the Essbase client installation directory. The Essbase adapter .exe file is registered within the FDM adapters folder and cannot locate esbapin.dll.
Solution: Register the Essbase adapter .exe file in the Essbase\Essbase Client\Bin directory.
To register the adapter:
Copy ES11xG4G.exe (or appropriate FDM Essbase adapter version .exe) to Oracle home\products\Essbase\Essbase Client\Bin.
Log in to the FDM application using an administrator account.
Select File, then Register Adapter, and then browse to the Oracle home\products\essbase\essbase client\bin directory and select the Oracle Essbase adapter .exe file.