Hi Gianni, Do you have any document or online material which can explain me more on how the ODI pull the ERP data and transform it, to store it into the OBIE warehouse. How to understand the ERP and Warehousing data mapping ? Regards, Rinki

Hi Gianni - What is MOD ? Do I need to post my query on any other forum , is this what you mean ? To be very honest, I'm not able to understand the difference between OBIA, OBIEE, ODI and how these are connected to each other. Do you have any document / note id which can help me building the understanding on these…

Yes, We have OBIA installed.

Thanks for the reply. But the Physical column tells about the Data Warehouse columns how to trace it to ERP table/column ? for example: I'm looking for column invoice_amount of table ap_invoices_all in presentation layer. How to trace from ERP to presentation layer? Regards, Rinki