Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

ISSUE - Integration of Oracle SQL Table with EPBCS using EPM Integration Agent

in Planning 11 comments

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!