Preface

This reference manual describes the Oracle PL/SQL packages shipped with the OLAP option of the Oracle Database.

Intended Audience

This reference manual is intended for database administrators and application developers who perform the following tasks:

• Administer a database

• Administer analytic workspaces

• Build and maintain data warehouses or data marts

• Define metadata

• Develop analytical applications

To use this document, you need no prior knowledge of Oracle OLAP.

Documentation Accessibility

Our goal is to make Oracle products, services, and supporting documentation accessible, with good usability, to the disabled community. To that end, our documentation includes features that make information available to users of assistive technology. This documentation is available in HTML format, and contains markup to facilitate access by the disabled community. Standards will continue to evolve over time, and Oracle is actively engaged with other market-leading technology vendors to address technical obstacles so that our documentation can be accessible to all of our customers. For additional information, visit the Oracle Accessibility Program Web site at

http://www.oracle.com/accessibility/

Accessibility of Code Examples in Documentation

JAWS, a Windows screen reader, may not always correctly read the code examples in this document. The conventions for writing code require that closing braces should appear on an otherwise empty line; however, JAWS may not always read a line of text that consists solely of a bracket or brace.

Structure

This document contains the following chapters.

Chapter 1, " Creating Analytic Workspaces with DBMS_AWM"

This chapter explains how to use the DBMS_AWM package.

Chapter 2, " Creating OLAP Catalog Metadata with CWM2 "

This chapter explains how to use the CWM2 packages.

Chapter 3, " Active Catalog Views "

This chapter describes the views in the Active Catalog.

Chapter 4, " Analytic Workspace Maintenance Views"

This chapter describes the views of analytic workspace maintenance information.

Chapter 5, " OLAP Catalog Metadata Views "

This chapter describes the views of OLAP Catalog metadata.

Chapter 6, " OLAP Fixed Views "

This chapter describes the dynamic performance views for Oracle OLAP.

Chapter 7, " CWM2_OLAP_CATALOG "

This chapter describes the syntax of the procedures in the CWM2_OLAP_CATALOG package.

Chapter 8, " CWM2_OLAP_CLASSIFY"

This chapter describes the metadata descriptors required by Oracle OLE DB for OLAP.

Chapter 9, " CWM2_OLAP_CUBE "

This chapter describes the syntax of the procedures in the CWM2_OLAP_CUBE package.

Chapter 10, " CWM2_OLAP_DIMENSION "

This chapter describes the syntax of the procedures in the CWM2_OLAP_DIMENSION package.

Chapter 11, " CWM2_OLAP_DIMENSION_ATTRIBUTE "

This chapter describes the syntax of the procedures in the CWM2_OLAP_DIMENSION_ATTRIBUTE package.

Chapter 12, " CWM2_OLAP_HIERARCHY "

This chapter describes the syntax of the procedures in the CWM2_OLAP_HIERARCHY package.

Chapter 13, " CWM2_OLAP_LEVEL"

This chapter describes the syntax of the procedures in the CWM2_OLAP_LEVEL package.

Chapter 14, " CWM2_OLAP_LEVEL_ATTRIBUTE "

This chapter describes the syntax of the procedures in the CWM2_OLAP_LEVEL_ATTRIBUTE package.

Chapter 15, " CWM2_OLAP_MEASURE"

This chapter describes the syntax of the procedures in the CWM2_OLAP_MEASURE package.

Chapter 16, " CWM2_OLAP_METADATA_REFRESH "

This chapter describes the syntax of the procedures in the CWM2_OLAP_METADATA_REFRESH package.

Chapter 17, "CWM2_OLAP_PC_TRANSFORM "

This chapter describes the syntax of the procedures in the CWM2_OLAP_PC_TRANSFORM package.

Chapter 18, "CWM2_OLAP_TABLE_MAP"

This chapter describes the syntax of the procedures in the CWM2_OLAP_TABLE_MAP package.

Chapter 19, " CWM2_OLAP_VALIDATE"

This chapter describes the syntax of the procedures in the CWM2_OLAP_VALIDATE package.

Chapter 20, " CWM2_OLAP_VERIFY_ACCESS "

This chapter describes the syntax of the procedures in the CWM2_OLAP_VERIFY package.

Chapter 21, " DBMS_AW "

This chapter describes the syntax of the procedures in the DBMS_AW package.

Chapter 22, " DBMS_AW_UTILITIES "

This chapter describes the syntax of the procedures in the DBMS_AW_UTILITIES package.

Chapter 23, " DBMS_AWM "

This chapter describes the syntax of the procedures in the DBMS_AWM package.

Chapter 24, " DBMS_ODM"

This chapter describes the syntax of the procedures in the DBMS_ODM package.

Chapter 25, " OLAP_API_SESSION_INIT "

This chapter describes the syntax of the procedures in the OLAP_API_SESSION_INIT package.

Chapter 26, "OLAP_TABLE"

This chapter describes the syntax of the OLAP_TABLE function.

Related Documents

For more information see these Oracle resources:

• Oracle OLAP Application Developer's Guide

  Explains how SQL and Java applications can extend their analytic processing capabilities by using Oracle OLAP.

• Oracle OLAP DML Reference

  Contains a complete description of the OLAP Data Manipulation Language (OLAP DML) used to define and manipulate analytic workspace objects.

• Oracle OLAP Developer's Guide to the OLAP API

  Introduces the Oracle OLAP API, a Java application programming interface for Oracle OLAP, which is used to perform OLAP queries of the data stored in an Oracle database. Describes the API and how to discover metadata, create queries, and retrieve data.

• Oracle OLAP Java API Reference

  Describes the classes and methods in the Oracle OLAP Java API for querying analytic workspaces and relational data warehouses.

• Oracle OLAP Analytic Workspace Java API Reference

  Describes the classes and methods in the Oracle OLAP Analytic Workspace Java API for building and maintaining analytic workspaces.

• Oracle Data Warehousing Guide

  Discusses the database structures, concepts, and issues involved in creating a data warehouse to support online analytical processing solutions.

• PL/SQL User's Guide and Reference

  Explains the concepts and syntax of PL/SQL, Oracle's procedural extension of SQL.

Conventions

The following conventions are also used in this manual: