Overview of Oracle Olap and Using SQL for Manipulate Multidimensional Data
There are many PL/SQL packages that you can use directly in SQL*Plus or indirectly in Analytic Workspace Manager and OLAP Worksheet. Using SQL you can manipulate multidimensional data and extract that data into a relational table. In this article I discussed about some methods that you can use for manipulating and extracting multidimensional data. Oracle OLAP provides support for business intelligence applications without the need for replicating large volumes of data in specialized analytical databases. Oracle OLAP allows applications to support complex multidimensional calculations directly against the data warehouse. The result is a single database that is more manageable, more scalable and accessible to the largest number of applications.
When requesting a correction, please mention this item's handle: RePEc:pet:annals:v:7:y:2006:p:355-362. See general information about how to correct material in RePEc.
For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: (Imola Driga)
If references are entirely missing, you can add them using this form.