9
Creating an Analytic Workspace From Relational Tables

You can use the AW_CREATE PL/SQL package to replicate a star schema within an analytic workspace and generate relational views of the resulting workspace cube. You can query these views directly using standard SQL. You can also create OLAP Catalog metadata that maps to these views to enable access by the OLAP API.

This chapter contains the following topics:

• Choosing to Use an Analytic Workspace
• Functional Summary
• Procedure: Create the OLAP Catalog Metadata
• Procedure: Create the Analytic Workspace Cube
• Procedure: Create SQL Access to the Analytic Workspace
• Column Structure of Dimension Views
• Column Structure of Fact Views