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: http://www.oracle.com/technology/products/bi/olap/index.html

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

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

 
%d bloggers like this: