Skip Headers

Oracle® OLAP Reference
10g Release 1 (10.1)

Part Number B10334-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

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:

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:

Conventions

The following conventions are also used in this manual:

Convention Meaning
.
.
.
Vertical ellipsis points in an example mean that information not directly related to the example has been omitted.
. . . Horizontal ellipsis points in statements or commands mean that parts of the statement or command not directly related to the example have been omitted
boldface text Boldface type in text indicates a term defined in the text, the glossary, or in both locations.
< > Angle brackets enclose user-supplied names.
[ ] Brackets enclose optional clauses from which you can choose one or none.
$ The dollar sign represents the DIGITAL Command Language prompt in Windows and the Bourne shell prompt in Digital UNIX