How to start with OBIEE reports!

User_JFDNL

Hi ,

I'm new to OBIEE reports and not able to find the proper way to look for respective ERP field in OBIEE presentation layer/Subject Area. Can anyone guide me on how to analyze the Subject Area and its field. and how to find the field in presentation layer for the ERP field

We are using:

ODI 11g

ERP 12.1.3

Regards, Rinki

[Deleted User]

Open the RPD, choose the presentation column you want, rigth-click and then "Query related objects" -> Physical Column

User_JFDNL

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

[Deleted User]

Depends on your ETL tool. Look there. Informatica, ODI, Talend, pure SQL...follow it back

Gianni Ceresa

Do you have a "packaged" product? Something like OBIA for example?

OBIEE comes empty, ODI comes empty. All these tools do not come with any content.

If you don't have a packaged product like OBIA, you must ask all the documentation to your own company as somebody there had to develop everything. Hopefully they developed with some kind of documentation (or I would highly question the quality of the result).

If you have OBIA or another packaged product, the question would need to be asked in the forum of that tool.

User_JFDNL

Yes, We have OBIA installed.

Gianni Ceresa

So ideally it's a question for or   (if you have MOS access).
Let's see if a mod can move the question there.

OBIA has a document/analysis explaining the models etc. Not sure it really goes back to the ERP itself, but being pre-packaged content (including the ETL) it's possible.

User_JFDNL

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 terminology.

Regards, Rinki

Gianni Ceresa

Hi, a MOD is a moderator of the forum. They already did the job, your question (thread) is now in the OBIA space and hopefully the users of the product will stop by ans give some hints.

OBIEE is a product, ODI is another product. OBIA is a pack of various product with pre-built content and connections between the pieces.

ODI is an ELT (ETL is also a valid way to define it), it takes care of moving data around and transform it based on rules and mappings. In your case it extra info from your ERP and transform it to store it into the OBIE warehouse and applying the various rules defined. It's OBIA which came with all those rules pre-defined.

OBIEE is the analytical/reporting platform, it will connect to the database and use it as source for analysis and reports. OBIEE will not connect to your ERP database but will connect to the OBIA warehouse instead, and on top of that one it comes with a ton of pre-built analysis and dashboards.

If you take tools individually you would spend weeks if not months designing a datawarehouse model, defining all the rules to extract data from your ERP and load in the warehouse. From there you would spend more weeks defining models and business rules to implement in OBIEE for analysis.

With OBIA you have a pre-package content which is supposed to match most of the needs out of the box, right after install.

User_JFDNL

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

Gianni Ceresa

Not really, I don't have any OBIA resource handy.

If you your Oracle account is linked to a valid Oracle Support identifier, you can ask in , there will be Oracle people able to give you all you look for.