15
CWM2_OLAP_AW_ACCESS

The CWM2_OLAP_AW_ACCESS package contains procedures for generating scripts that create views of analytic workspace objects. After running the scripts and creating the views, you can use standard SQL to access data stored in the analytic workspace. You can also use the views to define OLAP metadata so that OLAP API applications can access the multidimensional objects.

See Also:

Chapter 2, "Manipulating Multidimensional Data" for a discussion of analytic workspaces and the OLAP DML.
Chapter 3, "Developing OLAP Applications" for information about how this package fits into the process of preparing a database for use with OLAP applications.
Chapter 9, "Creating an Analytic Workspace From Relational Tables" for information on creating SQL access for analytic workspaces created by AW_CREATE.

This chapter contains the following topics:

When to Use the AW_ACCESS Package
Process Overview
Preparing the Analytic Workspace
Specifying the Source and Target Objects
Example: Creating Views
Summary of CWM2_OLAP_AW_ACCESS Subprograms

15 CWM2_OLAP_AW_ACCESS

15
CWM2_OLAP_AW_ACCESS