Clearing the Path to OLAP

Overview

The OLAP option in Oracle9i Database Release 2 introduced analytic workspaces and the true integration of relational and multidimensional datatypes in the same database. Until now, the only way developers and DBAs could use the analytic workspaces was to construct them manually by using command-line API calls. But with the recent release of the Analytic Workspace Manager (AWM), one can now make better use of the multidimensional features in the OLAP option for the first time without having to perform complex command-line programming. This paper introduces Analytic Workspace Manager and steps through the creation of a multidimensional cube stored in the analytic workspace that can be viewed via Oracle Business Intelligence (BI) Beans, OracleAS Discoverer, or SQL.