ISSUE - Integration of Oracle SQL Table with EPBCS using EPM Integration Agent
Hi all,
I am trying to integrate Oracle SQL table to EPBCS application using EPM Agent and Data Integration. Below is Oracle SQL table ("EPM_AGENT" is table name)
For now, I have provided the following as Dimension Mappings.
As you can observe, I have not mapped EMPLOYEES_ID to any dimension. Yet, when I start EPM Agent and run the import in Workbench, data available in EMPLOYEES_ID column is being considered for all the mapped dimensions including Amounts.
In the above screenshot, instead of considering data under DEPT_ID column in SQL table, EMPLOYYES_ID is being considered. I am unable to understand this behavior.
Tagged:
0