This content has been marked as final. Show 2 replies
The above questions are the real issues that raised by our partners who are developing data warehouse application for our customers in medical treatment industry.
it will be greately appreciate that you suggest any resolution.
You have not asked any specific technical question. In my opinion all Oracle Datawarehouses should use Oracle OLAP option for the Aggregation strategy. Significant improvements in 18.104.22.168 (and later versions) have been made. It has become much easier now to create and maintain dimensions/cubes. On the reporting side, OBIEE 11g now understands OLAP metadata. Other reporting tools can use the CUBE_TABLE views.
Here are some links that you may find useful.
Comparing MVs and OLAP... Oracle White paper
Oracle OLAP Support page
Three demos done by OLAP Development which explains how OLAP can help in a DW.
Main OLAP page at Oracle OTN site
Recommended Releases for Oracle OLAP
Accelerating Data Warehouses using OLAP option
What's new in 22.214.171.124 database OLAP option
Oracle 11.2 OLAP Documentation (scroll down to OLAP section)
Excel reporting from OLAP using Simba tool. This was developed in partnership with Oracle.
There is a good demo for Simba Excel tool at: