A colleague who is experienced in the Microsoft BI tools wanted to learn more about the OLAP capabilities in Oracle. Here are some links to get started which we thought we would share with our readers as well in case you are also interested in learning about it.
Developing Oracle OLAP Objects: http://www.oracle.com/technology/products/bib/htdocs/tutorials/developing_olap_objects/overview_developing_olap_objects.html
Oracle Warehouse Builder (OWB): http://www.oracle.com/technology/products/warehouse/index.html
Oracle self service education on OTN (Oracle Technology Network): http://www.oracle.com/technology/products/warehouse/selfserv_edu/self_service_education.html
OWB Dimensional Modeling: http://www.oracle.com/technology/products/warehouse/selfserv_edu/dimensional_modeling.html
All of the above links are very good starting points to pick up OLAP in Oracle. As you start to go through the links, there are many supporting documents listed on those pages and if you are already familiar with the MSFT solutions and tool sets, it won’t take you much time to start drawing parallels with how things work in Oracle.
And here are two good books on the topic – “The MultiDimensional Data Modeling Toolkit: Making your Business Intelligence Applications Smart with Oracle OLAP” and “Oracle Warehouse Builder 11g: Getting Started“.