Querying OLAP data using Oracle BI EE

Oracle recommends a Pure Relational, ROLAP, or MOLAP? for the following scenarios:

Select a purely relationalimplementation when

• The analytic requirements of the business are met by the capabilities of SQL.
• There are appropriate in-house SQL skills.
• The relational engine provides satisfactory query performance.
  

A purely relationalimplementation is designed and optimized to support the efficient movement and calculation of large volumes of data.

Select a ROLAPimplementation when …

• The analytic requirements of the business are met by the capabilities of SQL.
• User is looking for an easier way to formulate complex queries.
• The detail data is very sparse.
• Materialized Views to optimize performance.
  

Select a MOLAPimplementation …

• When the analytic requirements of the business need the extended analytic, forecasting and planning functionality of Multidimensional Database Technology.
• When the analysis includes lots of calculated and aggregated Key Performance Indicators
• Need an easier way to define complex or proprietary calculations.

I recommend Siebel Analytics/Oracle BI EE consultants to take the following tutorials from Oracle:

http://www.oracle.com/technology/obe/obe_bi/bi_ee_1013/olap/PrepareAW.htm

http://www.oracle.com/technology/obe/obe_bi/bi_ee_1013/olap/createmetadata.htm

http://www.oracle.com/technology/obe/obe_bi/bi_ee_1013/olap/QueryData.htm