FDM Classic to FDMEE Migration



Great resource for FDMEE from Franciscoa mores  and he has written more on FDMEE migration.
Please look at his blog

http://fishingwithfdmee.blogspot.com/2015/12/fdm-to-fdmee-migration-utility-11124.html


Oracle Official FDMEE migration Guide

http://docs.oracle.com/cd/E57185_01/epm.1112/fdm_migration.pdf

FDMEE - Shared Location

Shared Location in FDMEE

Like FDM Classic , FDMEE does provide  shared parent location feature.

Parent mapping used to share mappings with other locations. Enter mappings at the parent location, and the related locations can use the same mappings. Multiple locations can share a parent. This feature is useful when multiple locations use one chart of accounts.

Note: Changes to a child or parent mapping table are applied to all child and parent locations.



Go to Location Menu from the Setup menu.

Create Location and enter the Child location name  and in the bottom pane , you would see the location details

Go to parent location field and browse for the Parent location name.

Both this child and parent location would use the same mapping.

Hyperion FDMEE Data load failure Log analysis

Hyperion FDMEE Data load failure Log analysis

FDMEE different log file location and details

Audience : Hyperion Administrator / Hyperion Support / Development team.

1. Process Log

Whenever you trigger a load, FDMEE generates a process ID and log file in the FDMEE application folder under Outbox Folder.

Path : FDMEE Application Root Folder\Outbox\Logs  

You can find the process ID number from Data Management (FDMEE) console form workspace under process details menu.

Log file would be generated in the FDMEE Application Root Folder\Outbox\Logs  folder with target application name with process ID appended 

2.  ERPIntegrator0.log (FDMEE or ERPI log)

This is FDMEE application server log files. This would help you to find more detailed server errors 

\Oracle\Middleware\user_projects\domains\domain\servers\ErpIntergrator0\logs

3. ODI Agent Log

This is ODI agent log file. If ODI agent is not triggered / failed / timed out , please check this log.

\Oracle\Middleware/user_projects/domains/EPMSystem/servers/ErpIntegrator0/logs/oracledi

Manually Register HFM adapter  in  FDMEE 11.1.2.3.x

Steps:

Go to D:\Oracle\Middleware\user_projects\epmsystem1

Type the below Syntax

C:\windows\Microsoft.NET\Framework64\v4.0.30319\regsvcs.exe /tlb:”D:\Oracle\Middleware\user_projects\epmsystem1\FinancialDataQuality\erpiHFMAdapter.tlb” “D:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\lib\Windows\erpiHFMAdapter.dll”