Contents

Intended Audience

Documentation Accessi bility

Structure

Related Documents

Conventions

1 Creating Analytic Workspaces with DBMS_AWM

1.1 Overview

1 .1.1 Creating OLAP Catalog Metadata for the Source Cube

1.1.2 Creating and Populating Workspace Dimensions

1.1 .3 Creating and Populating Workspace Cubes

1.1.4 Aggregating the Cube's Data in the Analytic Workspace

1.1.5 Enabling Relational Access to the Workspace Cube

1.1.6 Viewing Metadata Created by DBMS_AWM

1.1.6.1 Active Catalog Views

1.1.6.2 Analytic Workspace M aintenance Views

1.2 Understanding the DBMS_AWM Procedures

1.2.1 Methods on Dime nsions

1.2.2 Methods on Cubes

1.2.3 Methods on Dimension Load Specifications

1.2.4 Methods on Cube Load Specifications

1.2.5 Methods on Aggregation Specifications

1.2.6 Methods on Composite Specifications

1.3 Creating and Refreshing a Workspace Dimension

1.3.1 Refreshing the Dimension's Metadata

1.3.2 When To Refresh a Dimension

1.3.3 What To Do After a Dimension Refresh

1.4 Creating and Refreshing a Workspace Cube

1.4.1 Data Ty pe Conversion

1.4.2 Refreshing the Cube's Metadata< /dd>

1.4.3 When To Refresh a Cube

1.4.4 What To Do After a Cube Refresh

1.5 Managing Sparse Data and Optimizing the Workspace Cube

1.5.1 Dimension Order

1.5.2 Creating and Modifying a Composite Specification

1.6 Aggregating the Data in an Analytic Workspace

1.6.1 Creating an Aggregation Specification

1.6.2 Choosing an Aggregation Method

1.7 Creating Relational Access to the Workspace Cube

1.7.1 Procedure: Generate and Run the Enablement Scripts

1.7.2 Procedure: Run the Enablement Scripts Automatically

1.7.3 The OLAP API Enabler Procedures

1.7.4 Enablement Metadata in the Analytic Workspace

1.7.5 Disabling Relational Access

1.7.6 Default Dimension View Names

1.7.7 Default Fac t View Names

1.7.8 Column Structure of Dimension Enabl ement Views

1.7.8.1 Sample Dimension View

1.7.8.2 Grouping ID Column

1.7.9 Column Structure of Enablement Fact Views

1.7.10 Example: Enable a Workspace Cube for Access by the OLAP API

2 Creating OLAP Catalog Metadata with CWM2

2.1 OLAP Metadata Entities

2.2 Creating a Dimension

2.2.1 Procedure: Create an OLAP Dimension

2.2.2 Example: Create a Product Dimension

2.2.3 Procedure: Create a Time Dimension

2.2.4 Example: Create a Time Dimension

2.3 Creating a Cube

2.3.1 Procedure: C reate a Cube

2.3.2 Example: Create a Costs Cube

< /dl>

2.4 Mapping OLAP Metadata

2.4.1 Mapping to Columns

2.4.1.1 Mapping Dimensions

2.4 .1.2 Mapping Measures

2.4.2 Joining Fact Tables with Dimension Tables

2.5 Validating an d Committing OLAP Metadata

2.5.1 Validating OLA P Metadata

2.5.2 Viewing Validity Status

2.5.3 Refreshing Metadata Tables for the OLAP API

2.6 Invoking the Procedures

2.6.1 Security Checks and Error Conditions

2.6.2 Size Requirements for Parameters

2.6.3 Case Requirements for Parameters

2.7 Directing Output

2.8 Viewing OLAP Metadata

3 Active Catal og Views

3.1 Standard Form Active Catalo g

3.1.1 Standard Form Classes

3.1.2 Active Catalog and Standard Form Classes

3.2 Example: Query an Analytic Workspace Cube

3.3 Summary of Active Catalog Views

3.4 ALL_OLAP2_AWS

3.5 ALL_OLAP2_AW_ATTRIBUTES

3.6 AL L_OLAP2_AW_CUBES

3.7 ALL_OLAP2_AW_CUBE_AGG_LVL

3.8 ALL_OLAP2_AW_CUBE_AGG_MEAS

3.9 ALL_OLAP2_AW_CUBE_AGG_OP

3.10 ALL_OLAP2_AW_CUBE_AGG_SPECS

3.11 ALL_OLAP2_AW_CUBE_DIM_USES

3.12 AL L_OLAP2_AW_CUBE_MEASURES

3.13 ALL_OLAP2_AW_DIMENSION S

3.14 ALL_OLAP2_AW_DIM_HIER_LVL_ORD

3.15 ALL_OLAP2_AW_DIM_LEVELS

3.16 ALL_OLAP2_AW_PHYS_OBJ

3.17 ALL_OLAP2_AW_PHYS_OBJ_PROP

4 Analytic Workspace Maintenance Views

4.1 Building and Maintaining Analytic Workspaces

4.2 Example: Query Load and Enablement Parameters for Workspace Dimensions

4.3 Summary of Analytic Workspace Maintenance Views

4.4 ALL_AW_CUBE_AGG_LEVELS

4.5 ALL_AW_CUBE_AGG_MEASURES

4.6 ALL_AW_CUBE_AGG_PLANS

4.7 ALL_AW_CUBE_EN ABLED_HIERCOMBO

4.8 ALL_AW_CUBE_ENABLED_VIEWS

4.9 ALL_AW_DIM_ENABLED_VIEWS

4.10 ALL_AW_LOAD_CUBES

4.11 ALL_AW_LOAD_CUBE_DIMS

4.12 AL L_AW_LOAD_CUBE_FILTERS

4.13 ALL_AW_LOAD_CUBE_MEASURES

4.14 ALL_AW_LOAD_CUBE_PARMS

4.15 ALL_AW_LOAD_DIMENSIONS

4.16 ALL_AW_LOAD_DIM_FILTERS

4.17 ALL_AW_LOAD_DIM_PARMS

4.18 ALL_AW_OBJ

4.19 ALL_AW_PROP

5 OLAP Catalog Metadata Views

< dd>5.1 Access to OLAP Catalog Views

5.2 Views of the Dimensional Model

5.3 Views of Mapping Information

5.4 ALL_OLAP2_AGGREGATION_USES

5.5 ALL_OLAP2_CATALOGS

5.6 ALL_OLAP2_CATALOG_ENTITY_USES

5.7 ALL_OLAP2_CUBES

5.8 ALL_OLAP2_CUBE_DIM_USES

5.9 ALL_OLAP2_CUBE_M EASURES

5.10 ALL_OLAP2_CUBE_MEASURE_MAPS

5.11 ALL_OLAP2_CUBE_MEAS_DIM_USES

5.12 ALL_OLAP2_DIMENSIONS

5 .13 ALL_OLAP2_DIM_ATTRIBUTES

5.14 ALL_OLAP2_DIM_AT TR_USES

5.15 ALL_OLAP2_DIM_HIERARCHIES

5.16 ALL_OLAP2_DIM_HIER_LEVEL_USES

5.17 ALL_OLAP2_DIM_LEVELS

5. 18 ALL_OLAP2_DIM_LEVEL_ATTRIBUTES

5.19 ALL_OLAP2_D IM_LEVEL_ATTR_MAPS

5.20 ALL_OLAP2_ENTITY_DESC_USES

5.21 ALL_OLAP2_ENTITY_EXT_PARMS

5.22 ALL_OLAP2_ENTITY_PARAMETERS

5.23 ALL_OLAP2_FACT_LEVEL_USES

5.24 ALL_OLAP2_FACT_TABLE_GID

5.25 ALL_OLAP2_HIER_CUSTOM_SORT< /a>

5.26 ALL_OLAP2_JOIN_KEY_COLUMN_USES

5.27 ALL_OLAP2_LEVEL_KEY_COL_USES

6 OLAP Fixed Views

6.1 System Tables Referenced by OLAP Fixed Views

6.2 Summary of OLAP Fixed Views

6.3 V$AW_AGGREGATE_OP

6.4 V$AW_ALLOCATE_OP

6.5 V$AW_CALC

6.6 V$AW_LONGOPS

6.7 V$AW_OLAP

6.8 V$AW_SESSION_INF O

7 CWM2_OL AP_CATALOG

7.1 Understanding Measure Folder s

7.2 Example: Creating a Measure Folder

< a href="cwm2_catalog.htm#sthref461">Summary of CWM2_OLAP_CATALOG Subprograms

ADD_CATALOG_ENTITY Procedure

CREATE_CATALOG Procedure

DROP_CATALOG Procedure

LOCK_CATALOG Procedure

REMOVE_CATALOG_ENTITY Procedure

SET_CATALOG_N AME Procedure

SET_DESCRIPTION Procedure

SET_PARENT_CATALOG Procedure

8 CWM2_OLAP_CLASSIFY

8.1 OLAP Catalog Metadata Descriptors

8.2 Example: Creating Descriptors

Summary of CWM2_OLAP_CLASSIFY Subprograms< /dd>

ADD_ENTITY_CARDINALITY_USE

ADD_ENTITY_DEFAULTMEMBER_USE

ADD_ENTITY_DENSEINDICATOR_USE

ADD_ENTITY_DESCRIPTOR_USE

ADD_ENTITY_FACTJOIN_USE

REMOVE_ENTITY_DESCRIPTOR_USE

9 CWM2_OLAP_CUBE

9.1 Understanding Cubes

9.2 Example: Creating a Cube

Summary of CWM2_OLAP_CUBE Subprograms

ADD_DIMENSION_TO_CUBE Procedure

CREAT E_CUBE Procedure

DROP_CUBE Procedure

LO CK_CUBE Procedure

REMOVE_DIMENSION_FROM_CUBE Procedure

SET_AGGREGATION_OPERATOR Procedure

SET_CUBE_NAME Procedure

SET_DEFAULT_CUBE_DIM_CALC_HIER Procedure

SET_DESCR IPTION Procedure

SET_DISPLAY_NAME Procedure

SET_MV_SUMMARY_CODE Procedure

SET_SHORT_DESCRIPTION Procedure

10 CWM2_OLAP_DIMEN SION

10.1 Understanding Dimensions

10.2 Example: Creating a CWM2 Dimension

Summary of CWM2_OLAP_DIMENSION Subprograms

CREATE_DIMENSION Procedure

DROP_DIMENSION Procedure

LOCK_DIMENSION Procedure

SET_DEFAULT_DISPLAY_HIERARCH Y Procedure

SET_DESCRIPTION Procedure

SET_DIMENSION_NAME Procedure

SET_DISPLAY_NAME Procedure

SET_PLURAL_NAME Procedure

SET_SHORT_DESCRIPTI ON Procedure

11 CWM2_OLAP_DIMENSION_ATTRIBUTE

11.1 Understanding Dimension Attributes

11.2 Example: Creating a Dimension Attribute

Summary of CWM2_OLAP_DIMENSION_ATTRIBUT E Subprograms

CREATE_DIMENSION_ATTRIBUTE Procedure

DROP_DIMENSION_ATTRIBUTE Procedure

LOCK_DIMENS ION_ATTRIBUTE Procedure

SET_DESCRIPTION Procedure

SET_DIMENSION_ATTRIBUTE_NAME Procedure

SET_DISPLAY_NAME P rocedure

SET_SHORT_DESCRIPTION Procedure

12 CWM2_OLAP_HIERARCHY

12.1 Understanding Hierarchies

12.2 Example: Creating a Hierarchy

Summary of CWM2_OLAP_HIERARCHY Subprograms

CREATE_HIERARCHY Procedure

DROP_HIERARCHY Procedure

LOCK_HIERARCHY Procedure

SET_DESCRIPTION Procedure

SET_DISPLAY_NAME Procedure

SET_HIERARCHY_NAME Proced ure

SET_SHORT_DESCRIPTION Procedure

SET_SOLVED_CODE Procedure

13 CWM2_OLAP_LEVEL

13. 1 Understanding Levels

13.2 Example: Creating a Le vel

Summary of CWM2_OLAP_LEVEL Subprograms

ADD_LEVEL_TO_HIERARCHY Procedure

CREATE_LEVEL Procedure

DROP_LEVEL Procedure

LOCK_LEVEL Procedure

REMOVE_LEVEL_FROM_HIERARCHY Procedure

SET_DES CRIPTION Procedure

SET_DISPLAY_NAME Procedure

SET_LEVEL_NAME Procedure

SET_PLURAL_NAME Procedure

SET_SHORT_DESCRIPTION Procedure

14 CWM2_OLAP_LEVEL_ATTRIBUTE

14.1 Understanding Level Attributes

14.2 Example: Creating Level Attributes

Summary of CWM2_OLAP_LEVEL_ATTRIBUTE Subprograms

CREATE_LEVEL_ATTRIBUTE Procedur e

DROP_LEVEL_ATTRIBUTE Procedure

LOCK_LEVEL_ATTRIBUTE Procedure

SET_DESCRIPTION Procedure

SET_DISPLAY_NAME Procedure

SET_LEVEL_ATTRIBU TE_NAME Procedure

SET_SHORT_DESCRIPTION Procedure

15 CWM2_OLAP_MEASURE

15.1 Understanding Measures

15.2 Example: Creating a Measure

Summary of CWM2_OLAP_MEASURE Subprograms

CREATE_MEASURE Procedure

DROP_MEASURE Procedure

LOCK_MEASURE Procedure

SET_DESCRIPTION Procedure

SET_DISPLAY_NAME Procedure

SET_MEASURE_NAME Procedure

SET_SHORT_DESCRIPTION Procedure

16 CWM2_OLAP_METADATA_REFRESH

16.1 Views of Cached OLAP Catalog Metadata

16.2 Views of Cached Active Catalog Metadata

Summary of CWM2_OLAP_METADATA_REFRESH Subprograms

MR_REFRESH Proc edure

MR_AC_REFRESH Procedure

17 CWM2_OLAP_PC_TRANSFORM