Systems Engineering and RDBMS

Archive for June 23rd, 2010

OLAP work in Oracle

Posted by decipherinfosys on June 23, 2010

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.

Oracle OLAP:

Developing Oracle OLAP Objects:

Oracle Warehouse Builder (OWB):

Oracle self service education on OTN (Oracle Technology Network):

OWB Dimensional Modeling:

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“.

Posted in Oracle, SQL Server | Leave a Comment »