Building and Maintaining Analytic Workspaces
Example: Query Load and Enablement Parameters for Workspace Dimensions
Summary of Analytic Workspace Maintenance Views
ALL_AW_CUBE_AGG_LEVELS
ALL_AW_CUBE_AGG_MEASURES
ALL_AW_CUBE_AGG_PLANS
ALL_AW_CUBE_ENABLED_HIERCOMBO
ALL_AW_CUBE_ENABLED_VIEWS
ALL_AW_DIM_ENABLED_VIEWS
ALL_AW_LOAD_CUBES
ALL_AW_LOAD_CUBE_DIMS
ALL_AW_LOAD_CUBE_FILTERS
ALL_AW_LOAD_CUBE_MEASURES
ALL_AW_LOAD_CUBE_PARMS
ALL_AW_LOAD_DIMENSIONS
ALL_AW_LOAD_DIM_FILTERS
ALL_AW_LOAD_DIM_PARMS
ALL_AW_OBJ
ALL_AW_PROP

5 OLAP Catalog Metadata Views

6 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

7 CWM2_OLAP_CATALOG

Understanding Measure Folders
Example: Creating a Measure Folder
Summary of CWM2_OLAP_CATALOG Subprograms

8 CWM2_OLAP_CLASSIFY

OLAP Catalog Metadata Descriptors
Example: Creating Descriptors
Summary of CWM2_OLAP_CLASSIFY Subprograms

9 CWM2_OLAP_CUBE

Understanding Cubes
Example: Creating a Cube
Summary of CWM2_OLAP_CUBE Subprograms

10 CWM2_OLAP_DELETE

Deleting OLAP Catalog Metadata
Summary of CWM2_OLAP_DELETE Subprograms

11 CWM2_OLAP_DIMENSION

Understanding Dimensions
Example: Creating a CWM2 Dimension
Summary of CWM2_OLAP_DIMENSION Subprograms

12 CWM2_OLAP_DIMENSION_ATTRIBUTE

Understanding Dimension Attributes
Example: Creating a Dimension Attribute
Summary of CWM2_OLAP_DIMENSION_ATTRIBUTE Subprograms

13 CWM2_OLAP_EXPORT

Exporting and Importing OLAP Catalog Metadata
Creating a Metadata Command Script
Creating an Export Parameter File
Summary of CWM2_OLAP_Export Subprograms

14 CWM2_OLAP_HIERARCHY

Understanding Hierarchies
Example: Creating a Hierarchy
Summary of CWM2_OLAP_HIERARCHY Subprograms

15 CWM2_OLAP_LEVEL

Understanding Levels
Example: Creating a Level
Summary of CWM2_OLAP_LEVEL Subprograms

16 CWM2_OLAP_LEVEL_ATTRIBUTE

Understanding Level Attributes
Example: Creating Level Attributes
Summary of CWM2_OLAP_LEVEL_ATTRIBUTE Subprograms

17 CWM2_OLAP_MANAGER

Managing Output in a SQL*Plus Session
Example: Using a Log File
Summary of CWM2_OLAP_MANAGER Subprograms

18 CWM2_OLAP_MEASURE

Understanding Measures
Example: Creating a Measure
Summary of CWM2_OLAP_MEASURE Subprograms

19 CWM2_OLAP_METADATA_REFRESH

Views of Cached OLAP Catalog Metadata
Views of Cached Active Catalog Metadata
Summary of CWM2_OLAP_METADATA_REFRESH Subprograms
- MR_REFRESH Procedure
- MR_AC_REFRESH Procedure

20 CWM2_OLAP_PC_TRANSFORM

Prerequisites
Parent-Child Dimensions
Solved, Level-Based Dimensions
Example: Creating a Solved, Level-Based Dimension Table
- Grouping ID Column
- Embedded Total Key Column
Summary of CWM2_OLAP_PC_TRANSFORM Subprograms
- CREATE_SCRIPT Procedure

21 CWM2_OLAP_TABLE_MAP

Understanding OLAP Catalog Metadata Mapping
Example: Mapping a Dimension
Example: Mapping a Cube
Summary of CWM2_OLAP_TABLE_MAP Subprograms

22 CWM2_OLAP_VALIDATE

About OLAP Catalog Metadata Validation
Summary of CWM2_OLAP_VALIDATE Subprograms

23 CWM2_OLAP_VERIFY_ACCESS

Validating the Accessibility of an OLAP Cube
Summary of CWM2_OLAP_VERIFY_ACCESS Subprograms
- VERIFY_CUBE_ACCESS Procedure

24 DBMS_AW

Managing Analytic Workspaces
- Converting an Analytic Workspace to Oracle 10g Storage Format
- - Procedure: Convert an Analytic Workspace from 9i to10g 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
Using the Aggregate Advisor
- Aggregation Facilities within the Workspace
- Example: Using the ADVISE_REL Procedure
Summary of DBMS_AW Subprograms

25 DBMS_AW_XML

Analytic Workspace Java API Overview
Oracle OLAP XML Schema
Summary of DBMS_AW_XML Subprograms
- EXECUTE Function
- EXECUTEFILE Function

26 DBMS_AWM

Parameters of DBMS_AWM Subprograms
Summary of DBMS_AWM Subprograms

27 DBMS_ODM

Materialized Views for the OLAP API
Example: Automatically Generate the Minimum Grouping Sets for a Cube
Example: Manually Choose the Grouping Sets for a Cube
Summary of DBMS_ODM Subprograms

28 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

29 OLAP_CONDITION

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

30 OLAP_EXPRESSION

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

31 OLAP_EXPRESSION_BOOL

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

32 OLAP_EXPRESSION_DATE

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

33 OLAP_EXPRESSION_TEXT

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

34 OLAP_TABLE

OLAP_TABLE Overview
OLAP_TABLE Examples
OLAP_TABLE Syntax

Contents