15
CWM2_OLAP_AW_ACCESS

The CWM2_OLAP_AW_ACCESS package contains procedures for generating scripts that create views of 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.

This chapter contains the following topics:

• Prerequisites
• Process Overview
• Preparing the Analytic Workspace
• Specifying the Source and Target Objects
• Example: Creating Views
• Summary of CWM2_OLAP_AW_ACCESS Subprograms