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

Posted in Oracle, SQL Server | Leave a Comment »

 
Follow

Get every new post delivered to your Inbox.

Join 80 other followers