Is OBIEE all in one for ETL, Cubes Development n BI Reporting?

Community DW Integration

Thank you Gurus

I think this question has produced enough knowledge for Newbees like me to get start with Oracle BI tools.

If I've understood the above discussion correctly, the pathway for Oracle based BI development is:

• Create Data Warehouse based data model in Oracle Database
• Do the ETL (if needed, and practically it is really needed) using ODI
• Generate presentation layer using OBIEE

[Deleted User]

Just to make one thing clear:

If you are talking about pure OBIEE, then steps 1 and 2 are optional because OBIEE can analyze anything. You wouldn't for example put your data from Essabse cubes into a DWH again. Or from a Hadoop source etc.

Your question was extremely generic so the answers were generic. You can't take them and consider them an absolute and inviolte truth that is to be followed in absolute and all the time.

Thomas Dodds

• Create Data Warehouse based data model in Oracle Database
• Do the ETL (if needed, and practically it is really needed) using ODI
• Generate presentation layer using OBIEE

Not if you are doing Transactional Business Intelligence ....