Oracle OLAP
From Oracle FAQ
Oracle OLAP is an separately licensable option of the Oracle database that offers an embedded multidimensional calculation engine within the database. It is only available with Oracle Enterprise Edition.
With Oracle OLAP, all data is accessible through standard SQL.
History
Oracle OLAP Option was originally called Express, but was subsequently integrated into the Oracle database.
Some of the highlights:
- Oracle purchased Express and related applications from IRI in 1995
- Oracle introduced Sales Analyser (OSA) and Financial Analyser (OFA) on top of Oracle Express in 1996.
- Express was integrated into the Oracle 9i database in 2002.
- Continuous improvments were made in Oracle 10g and Oracle 11g.
Creating an Analytic Workspace
The first step after installing Oracle OLAP is to create an "analytic workspace." Start up the OLAP Analytic Workspace Manager GUI that ships with the Oracle Client CD. Log in as your schema owner, select Tools -> OLAP Worksheet and execute:
aw create my_first_aw
Proceed by creating your dimensions. For example:
CREATE country DIMENSION TEXT
After creating the dimensions, we need to create a variable to hold the transactional data:
DEFINE sales VARIABLE NUMBER (10,2) <list your dimensions here>
To add data into our dimensions, execute:
MAINTAIN city ADD 'NEW YORK'
