FDM - HFM adapter

                                                         Register HFM adapter

1. First extract hfm adapter to the following location::

D:\Hyperion\Middleware\EPMSystem11R1\products\FinancialDataQuality\SharedComponents

 

2. Open FDM application then first import adapter. Browse the FM11X-G5-E file from shared Components.

3. Once import done, the Register adapter with fdmFM11XG5E.dll from the Shared Components\AdapterComponents\fdmFM11xG5E

4.  Then create Machine profile with source and Target Server details

5.  After creating application if FDM application giving issue to integrate with HFM application, then we need to enable same number of custom dimensions on FDM application. Then we can see Target Period, Year etc from FDM.

Thanks,

Mady

FDM application 11.1.2+

                             How to create FDM application in 11.1.2.1+

1.       FDM works on 32-bit mode only even if you have installed on 64-bit machine.

2.       Create schema on oracle database with below::

Privileges::

CREATE SESSION,CREATE VIEW,CREATE TYPE,CREATE TABLE,CREATE CLUSTER,CREATE TRIGGER,CREATE SEQUENCE,CREATE INDEXTYPE,CREATE PROCEDURE,CREATE ANY SYNONYM,DROP ANY SYNONYM,UNLIMITED TABLESPACE

Roles: Connect, Resource and DBA.

3. We can check connect of FDM schema connectivity using udl32 file.

• Create a text file and save as with udl32 extension.
• Launch a command prompt.
• Execute the following command like below::

C:\WINDOWS\SysWOW64\Rundll32.exe "c:\Program Files (x86)\Common Files\System\Ole DB\oledb32.dll",OpenDSLFile c:\testconn.udl32

4. Udl32 file will open now. You can check connectivity.

5. Create FDM application with same schema details.

6. Check the upsLBMgr.exe process in Task Manager which shows the application creation progress

7. If you get “Object variable or with block variable not set”

• Check FDM service account has permissions.
• If you are giving UNC path (if it is load balance), check folder permissions and try / and \
• If you are UNC Path, try with drive name while creating application later you can change to UNC path.
• If FDM version 11.1.2.1, we need to apply patch. Patch number—12795642
• If FDM 11.1.1.4 version, we need to apply patch. Patch number--13336220 (PSU 102)

Thanks,

Mady