The Oracle OLAP option of Oracle Database 10g Enterprise Edition provides advanced analytic features to help us to summarize, analyze and calculate data faster than standard SQL. In this article I discussed about the CWM2, a set of PL/SQL packages which are using to create the OLAP Catalog...

Using SQL you can manipulate multidimensional data and extract that data into a relational table. There are many PL/SQL packages that you can use directly in SQL*Plus or indirectly in Analytic Workspace Manager and OLAP Worksheet. In this article I discussed about some methods that you can use...