I presented at New England Oracle Applications User Group conference this month on how to build a flexible BI infrastructure if you have Oracle Applications and, have licenses for Daily Business Intelligence. I did the project using Oracle Business Intelligence Enterprise Edition (erstwhile Siebel Analytics), but in reality, you can use this approach with virtually any BI tool from Business Objects, Cognos or any other. Financials, HR and the Distribution Modules (OM, Inventory, PO) are the easiest to implement.

If you want more details on all the fact and dimension tables for these modules, feel free to drop me a line.

Presentation: How to build BI on Oracle eBS