Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Active Catalog Views

• Understanding the Active Catalog
• Summary of Active Catalog Views
• ALL_OLAP2_AWS
• ALL_OLAP2_AW_ATTRIBUTES
• ALL_OLAP2_AW_CATALOGS
• ALL_OLAP2_AW_CATALOG_MEASURES
• ALL_OLAP2_AW_CUBES
• ALL_OLAP2_AW_CUBE_AGG_LVL
• ALL_OLAP2_AW_CUBE_AGG_MEAS
• ALL_OLAP2_AW_CUBE_AGG_OP
• ALL_OLAP2_AW_CUBE_AGG_SPECS
• ALL_OLAP2_AW_CUBE_DIM_USES
• ALL_OLAP2_AW_CUBE_MEASURES
• ALL_OLAP2_AW_DIMENSIONS
• ALL_OLAP2_AW_DIM_HIER_LVL_ORD
• ALL_OLAP2_AW_DIM_LEVELS
• ALL_OLAP2_AW_PHYS_OBJ
• ALL_OLAP2_AW_PHYS_OBJ_PROP

2 OLAP Dynamic Performance Views

• V$ Tables for OLAP
• Summary of OLAP Dynamic Performance Views
• V$AW_AGGREGATE_OP
• V$AW_ALLOCATE_OP
• V$AW_CALC
• V$AW_LONGOPS
• V$AW_OLAP
• V$AW_SESSION_INFO

3 DBMS_AW

• Managing Analytic Workspaces
  • Converting an Analytic Workspace to Oracle 10g Storage Format
    • Procedure: Convert an Analytic Workspace to the Latest Storage Format
    • Procedure: Import a workspace from a 9i Database into a 10g Database
• Embedding OLAP DML in SQL Statements
  • Methods for Executing OLAP DML Commands
  • Guidelines for Using Quotation Marks in OLAP DML Commands
• Using the Sparsity Advisor
  • Data Storage Options in Analytic Workspaces
  • Selecting the Best Data Storage Method
  • Using the Sparsity Advisor
  • Example: Evaluating Sparsity in the GLOBAL Schema
    • Advice from Sample Program
    • Information Stored in AW_SPARSITY_ADVICE Table
• Using the Aggregate Advisor
  • Aggregation Facilities within the Workspace
  • Example: Using the ADVISE_REL Procedure
• Summary of DBMS_AW Subprograms
  • ADD_DIMENSION_SOURCE Procedure
  • ADVISE_CUBE Procedure
  • ADVISE_DIMENSIONALITY Function
  • ADVISE_DIMENSIONALITY Procedure
  • ADVISE_PARTITIONING_DIMENSION Function
  • ADVISE_PARTITIONING_LEVEL Function
  • ADVISE_REL Procedure
  • ADVISE_SPARSITY Procedure
    • Output Description
  • AW_ATTACH Procedure
  • AW_COPY Procedure
  • AW_CREATE Procedure
  • AW_DELETE
  • AW_DETACH Procedure
  • AW_RENAME Procedure
  • AW_TABLESPACE Function
  • AW_UPDATE Procedure
  • CONVERT Procedure
  • EVAL_NUMBER Function
  • EVAL_TEXT Function
  • EXECUTE Procedure
  • GETLOG Function
  • INFILE Procedure
  • INTERP Function
  • INTERPCLOB Function
  • INTERP_SILENT Procedure
  • OLAP_ON Function
  • OLAP_RUNNING Function
  • PRINTLOG Procedure
  • RUN Procedure
  • SHUTDOWN Procedure
  • SPARSITY_ADVICE_TABLE Procedure
  • STARTUP Procedure

4 DBMS_AW_XML

• Using DBMS_AW_XML
• Summary of DBMS_AW_XML Subprograms
  • EXECUTE Function
  • EXECUTEFILE Function
  • READAWMETADATA Function

5 OLAP_API_SESSION_INIT

• Initialization Parameters for the OLAP API
• Viewing the Configuration Table
  • ALL_OLAP_ALTER_SESSION View
• Summary of OLAP_API_SESSION_INIT Subprograms
  • ADD_ALTER_SESSION Procedure
  • CLEAN_ALTER_SESSION Procedure
  • DELETE_ALTER_SESSION Procedure

6 OLAP_CONDITION

• OLAP_CONDITION Overview
  • Entry Points in the Limit Map
  • Dynamically Modifying a Workspace during a Query
• OLAP_CONDITION Examples
• OLAP_CONDITION Syntax

7 OLAP_EXPRESSION

• OLAP_EXPRESSION Overview
  • Single-Row Functions
  • OLAP_EXPRESSION and OLAP_TABLE
• OLAP_EXPRESSION Examples
• OLAP_EXPRESSION Syntax

8 OLAP_EXPRESSION_BOOL

• OLAP_EXPRESSION_BOOL Overview
  • Single-Row Functions
  • OLAP_EXPRESSION_BOOL and OLAP_TABLE
• OLAP_EXPRESSION_BOOL Example
• OLAP_EXPRESSION_BOOL Syntax

9 OLAP_EXPRESSION_DATE

• OLAP_EXPRESSION_DATE Overview
  • Single-Row Functions
  • OLAP_EXPRESSION_DATE and OLAP_TABLE
• OLAP_EXPRESSION_DATE Syntax

10 OLAP_EXPRESSION_TEXT

• OLAP_EXPRESSION_TEXT Overview
  • Single-Row Functions
  • OLAP_EXPRESSION_TEXT and OLAP_TABLE
• OLAP_EXPRESSION_TEXT Syntax

11 OLAP_TABLE

• OLAP_TABLE Overview
  • Limit Maps
  • Logical Tables
  • Using OLAP_TABLE With Predefined ADTs
  • Using OLAP_TABLE With Automatic ADTs
  • Using a MODEL Clause
• OLAP_TABLE Examples
  • Example: Creating Views of Embedded Total Dimensions
  • Example: Creating Views of Embedded Total Measures
  • Example: Creating Views in Rollup Form
  • Using OLAP_TABLE with the FETCH Command
• OLAP_TABLE Syntax
  • Analytic Workspace Parameter
    • owner
    • QUERY
    • SESSION
  • Table Object Parameter
  • OLAP Command Parameter
  • Limit Map Parameter
    • Limit Map: MEASURE Clause
    • Limit Map: DIMENSION Clause
    • Limit Map: WITH Subclause for Dimension Hierarchies and Attributes
    • Limit Map: DIMENSION Clause: WITH HIERARCHY Subclause
    • Limit Map: DIMENSION Clause: WITH ATTRIBUTE Subclause
    • Limit Map: ROW2CELL Clause
    • Limit Map: LOOP Clause
    • Limit Map: PREDMLCMD Clause
    • Limit Map: POSTDMLCMD Clause
  • Order of Processing in OLAP_TABLE

Index