Systems Engineering and RDBMS

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

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: