This content has been marked as final. Show 1 reply
Well .. this is a larger discussion, which will require understanding your data, reporting requirements, amount of data, hardware and other resources available, SLA for cube loading and for reporting etc.
The aggregation strategy (in any Oracle-based-DW) should involve Oracle-OLAP and calculations.
If you are new to Oracle-OLAP then do listen to these 3 presentations on Oracle-OLAP, done by Bud Endress from OLAP Development team.
Also look at:
COMPARING OLAP CUBES and MVs
OBIEE 188.8.131.52 and ORACLE-OLAP CUBES
Oracle-OLAP on EXADATA
Search this forum for old posts. Lot of questions and challenges that you will come across have already been answered on this forum.