Tips:   

FDMEE data load mapping validation fails when all the mapping  are correct. 


If you get FDMEE data load validation during data load when all the mapping are correct, like below error message in the FDMEE process detail Logs:

RuntimeError: [u"Error: Data rows with unmapped dimensions exist for Period '30NOV2016'"]

Cause:   If the system has duplicate mapping rows for any dimension, then validation would fail with the below error message in the process details.

Error message:
File "<string>", line 1788, in updateTDATASEG_T_TDATASEGW
SQLException: java.sql.SQLException: ORA-01427: single-row subquery returns more than one row.

Error message:

RuntimeError: [u"Error: Data rows with unmapped dimensions exist for Period '30NOV2016'"]

Then the problem could be duplicate rows are present in the member mapping. 

Looks for duplicate rows from data load mapping 

Delete the duplicate mapping row and re-execute the data load rule.

Mapping Audit features in FDMEE

Mapping Audit features in FDMEE

Map audit Reports show changes made to the data load mapping rules using any of the methods data load mappings UI, Excel template imports, text file imports, and Lifecycle Management imports.

1.      Enable Map Monitoring Reports from system setting

2.      Make sure the Enable Map Audit is set to Yes

3.      Run the report

4.      Go to Report Execution from Task tab

5.      Select Audit Reports from Report Group

      Select the Map Monitor for Location report

It will display a list of mapping changes, additions, and deletions made for a location based on a date range

6.      Click Execute

7.       Select the location where you want to run the mapping audit reports

         Select the action type as All

         Define the date as given format, (We can ignore the dates as well)

8. Click Ok

Mapping auditing report would be opened in .PDF file

 Reports contain data load mappings from:

Data load mapping option

Text file imports

Lifecycle Management imports

We can also generate based on user who has updated the mapping by selecting

Map Monitor for User report

Displays a list of mapping changes, additions, and deletions made by a user based on a date range

FDMEE Performance tuning tips

FDMEE Performance tuning Guide

This tips are applicable to 11.1.2.3.000 or higher version

1.      JVM tuning

2.      Data Sources

3.      Batch Size

4.      ODI (Oracle Data integrator) setting

5.      Database

Configure JVM Tuning for ERPI (FDMEE)

1JVM Tuning

The JVM (Java Virtual Machine) allocates and manages the heap memory based on how much each Java application needs. When a Java application is running, the systematic usage and release of heap memory is managed through a “garbage collector”.

The two settings to change for heap memory are:

-Xms   - the minimum size of the heap

-Xmx   - the maximum size of the heap

VM Heap Registry Settings in Windows Server

1.      Open the Windows Registry.

2.      Navigate to: HKEY_LOCAL_MACHINE\SOFTWARE\Hyperion Solutions\ErpIntegrator(n)\HyS9aifWeb_epmsystem(n) Where ErpIntegrator(n)

3.      (ErpIntegrator0, ErpIntegrator1, depending on how many FDMEE web servers are deployed and which server you are updating.

4.      Locate the two JVMOptions –Xms and –Xmx   (Data Type is REG_SZ).

5.      Double click the option to change. (For example, JVMOptionnn)

6.      In the Value Data, change the numerical value of –Xms2064m to the new value,

7.      Repeat this step for the –Xmx value.

8.      Restart the HyS9aifWeb service.

Note:   -Xms and –Xmx values should be set to the same number

In Linux Server

To change the JVM heap entries for Linux do the following:

1. Edit this file: /user_projects/epmsystemx/bin/deploymentScripts/setCustomParamsErpIntegrator.sh.

 2. Find the section JAVA_OPTS=”-Xms512m –Xmx512m….”

3. Change the numerical values to the new desired heap memory value, save the changes.

4. Restart the “Oracle Hyperion FDM Enterprise Edition - Java Web App” service.

2  Weblogic Data Sources:

Increase the default number of data sources. WebLogic data sources are the number of pooled connections made available to FDMEE for a JDBC (database) data source.

Tips…  for error

If your application runs out of WebLogic data sources you might see in your log file, “ResourceLimitException”, or “Reached maximum capacity of pool”.

To start Oracle WebLogic Server Administration Console:

1.      Select Start, then Programs, then Oracle WebLogic, then User Projects, then EPMSystem, and then Start Admin Server for WebLogic Server Domain.

2.      When the Admin Server displays “RUNNING”,

3.      Select Start, then Programs, then Oracle WebLogic, then User Projects, then EPMSystem, and then Admin Server Console.

4.       To access the WebLogic Server Administration Console from the browser type in the following URL: » http://servername:7001/console

5.      Login to WebLogic Server Administration Console with the credentials used during the system configuration

6.      From Domain Structure, select Services, and then Data Sources.

7.      Select either aif_datasource or odiMasterRepository by selecting the hyperlink in the Name column.

8.      Select the Configuration tab and then the Connection Pool tab

9.      Click Lock & Edit button to modify the “Maximum Capacity” setting.

10.   In Maximum Capacity, type the new value for the data source connections.

11.   Once the setting is changed, click Save. Repeat steps four through eight to change the odiMasterRepository data source connection pool.

3Batch Size:

Specify the number of rows read at a time from the file to memory. This parameter is mainly used for performance.

Batch Size Batch Size refers to the number of import records that are “batched up” before a commit occurs on the database.

The “Batch Size” parameter is set at the system level.

Default setting for “Batch Size” is 1000.

This setting is changed by selecting Data Management, then on the Setup tab, select Configure, System Settings. On the System Settings screen, type the new value in the Batch Size field and click Save.

Smaller imports, such as < 10,000 records, would suffice to use the default batch size.  If you have < 100000 records , keep the batch size setting as 10000.

Note: A setting too large or too small can have adverse performance effects.

4Oracle Data Integrator (ODI)

ODI has three significant tuning components to explore if you are having problems loading large data sets.

a.      Array Fetch Size  

b.      Batch Update Size   (These can be found in “Topology” tab of ODI Studio in the Physical Architecture section for your data server.

c.      Maximum number of sessions   (The Maximum number of sessions setting is found under the agent.

Tips..

Optimal values for

Array Fetch Size and Batch Update Size is “100”   for better performance, low memory and CPU usage.

Open ODI Studio and connect to FDMEE repositories

Go ODI Navigator

Go to   Physical architecture à Technologies à Oracle à Data Server  ( EBS_DATA_SERVER or FDMEE_DATA_SERVER)

The “Maximum number of sessions” value depends on the capabilities of the machine running the agent. Oracle Data Integrator allows you to load balance parallel session execution between physical agents. Each agent has a maximum number of sessions it can execute simultaneously from a work repository.

The default value for Maximum number of sessions is 1000

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”