1 Creating Analytic Workspaces with DBMS_AWM

The DBMS_AWM package provides stored procedures for creating and maintaining analytic workspaces.

The DBMS_AWM package is used by Analytic Workspace Manager. This chapter explains how to create your own scripts that use the DBMS_AWM procedures directly.

See Also:

Chapter 26, "DBMS_AWM" for the complete syntax of the procedures in this package
Chapter 3, "Active Catalog Views" for descriptions of the views that expose the logical structures within analytic workspaces
Chapter 4, "Analytic Workspace Maintenance Views" for descriptions of the views that expose information stored in the OLAP Catalog by DBMS_AWM procedures

This chapter contains the following topics:

Overview
Understanding the DBMS_AWM Procedures
Creating and Refreshing a Workspace Dimension
Creating and Refreshing a Workspace Cube
Managing Sparse Data and Optimizing the Workspace Cube
Aggregating the Data in an Analytic Workspace
Enabling Access by the OLAP API
Enabling Relational Access