Oracle® OLAP Reference 10g Release 1 (10.1) Part Number B10334-02 |
|
|
View PDF |
This reference manual describes the Oracle PL/SQL packages shipped with the OLAP option of the Oracle Database.
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.
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/
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.
This document contains the following chapters.
This chapter explains how to use the DBMS_AWM
package.
This chapter explains how to use the CWM2
packages.
This chapter describes the views in the Active Catalog.
This chapter describes the views of analytic workspace maintenance information.
This chapter describes the views of OLAP Catalog metadata.
This chapter describes the dynamic performance views for Oracle OLAP.
This chapter describes the syntax of the procedures in the CWM2_OLAP_CATALOG
package.
This chapter describes the metadata descriptors required by Oracle OLE DB for OLAP.
This chapter describes the syntax of the procedures in the CWM2_OLAP_CUBE
package.
This chapter describes the syntax of the procedures in the CWM2_OLAP_DIMENSION
package.
This chapter describes the syntax of the procedures in the CWM2_OLAP_DIMENSION_ATTRIBUTE
package.
This chapter describes the syntax of the procedures in the CWM2_OLAP_HIERARCHY
package.
This chapter describes the syntax of the procedures in the CWM2_OLAP_LEVEL
package.
This chapter describes the syntax of the procedures in the CWM2_OLAP_LEVEL_ATTRIBUTE
package.
This chapter describes the syntax of the procedures in the CWM2_OLAP_MEASURE
package.
This chapter describes the syntax of the procedures in the CWM2_OLAP_METADATA_REFRESH
package.
This chapter describes the syntax of the procedures in the CWM2_OLAP_PC_TRANSFORM
package.
This chapter describes the syntax of the procedures in the CWM2_OLAP_TABLE_MAP
package.
This chapter describes the syntax of the procedures in the CWM2_OLAP_VALIDATE
package.
This chapter describes the syntax of the procedures in the CWM2_OLAP_VERIFY
package.
This chapter describes the syntax of the procedures in the DBMS_AW
package.
This chapter describes the syntax of the procedures in the DBMS_AW_UTILITIES
package.
This chapter describes the syntax of the procedures in the DBMS_AWM
package.
This chapter describes the syntax of the procedures in the DBMS_ODM
package.
This chapter describes the syntax of the procedures in the OLAP_API_SESSION_INIT
package.
This chapter describes the syntax of the OLAP_TABLE
function.
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.
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.
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.
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 |