SAP ERP to Oracle EPM Mappings
Summary:
Content (please ensure you mask any confidential information):
Hi
We have below scenario with a client.
Client is using SAP as its Core ERP. and we are extracting actuals to budget from SAP.
SAP has three dimensions namely, GL Account, Cost Center and Functional Area for us to extract.
Functional area is what SAP uses as reporting. However Report requirements in Oracle is different to SAP, so we cannot make use of Functional area dimension for Oracle Reporting.
Because of it, we have created mappings in EPBCS Rules as below for each report area, combining 3 dimensions. (GL,CC, and FA) It should be noted that, there are no parent child hierarchy relationships for this client, and its GL hierarchy and CC hierarchy is built with lots of ineffiencies, where we cannot use any sort of a range to define a report area. Hence the mapping is built as below