List of Tables

1-1 Logical Entities in the DBMS_AWM Package

1-2 Methods on Dimensions in DBMS_AWM

1-3 Methods on Cubes in DBMS_AWM

1-4 Methods on Dimension Load Specifications in DBMS_AWM

1-5 Methods on Cube Load Specifications in DBMS_AWM

1-6 Methods on Aggregation Specifications in DBMS_AWM

1-7 Methods on Composite Specifications in DBMS_AWM

1-8 Conversion of RDBMS Data Types to Workspace Data Types

1-9 Composite Spec Members for XADEMO.ANALYTIC_CUBE

1-10 Aggregation Operators

1-11 The OLAP API Enabler Procedures

1-12 Sample Dimension Hierarchies

1-13 Dimension View Columns

1-14 Sample Dimension/Hierarchy Combinations

1-15 Fact View Columns

2-1 Hierarchical Relationships Between Components of a Dimension

2-2 Size Limitations of CWM2 Metadata Entities

3-1 Active Catalog Views

4-1 Analytic Workspace Maintenance Views

5-1 OLAP Catalog Dimensional Model Views

5-2 OLAP Catalog Mapping Views

6-1 OLAP Fixed Views

7-1 CWM2_OLAP_CATALOG Subprograms

7-2 ADD_CATALOG_ENTITY Procedure Parameters

7-3 CREATE_CATALOG Procedure Parameters

7-4 DROP_CATALOG Procedure Parameters

7-5 LOCK_CATALOG Procedure Parameters

7-6 REMOVE_CATALOG_ENTITY Procedure Parameters

7-7 SET_CATALOG_NAME Procedure Parameters

7-8 SET_DESCRIPTION Procedure Parameters

7-9 SET_PARENT_CATALOG Procedure Parameters

8-1 OLAP Catalog Metadata Descriptors

8-2 CWM2_OLAP_CLASSIFY Subprograms

8-3 ADD_ENTITY_CARDINALITY_USE Procedure Parameters

8-4 ADD_ENTITY_DEFAULTMEMBER_USE Procedure Parameters

8-5 ADD_ENTITY_DENSEINDICATOR_USE Procedure Parameters

8-6 ADD_ENTITY_DESCRIPTOR_USE Procedure Parameters

8-7 ADD_ENTITY_FACTJOIN_USE Procedure Parameters

8-8 REMOVE_ENTITY_DESCRIPTOR_USE Procedure Parameters

9-1 CWM2_OLAP_CUBE Subprograms

9-2 ADD_DIMENSION_TO_CUBE Procedure Parameters

9-3 CREATE_CUBE Procedure Parameters

9-4 DROP_CUBE Procedure Parameters

9-5 LOCK_CUBE Procedure Parameters

9-6 REMOVE_DIMENSION_FROM_CUBE Procedure Parameters

9-7 SET_AGGREGATION_OPERATOR Procedure Parameters

9-8 SET_CUBE_NAME Procedure Parameters

9-9 SET_DEFAULT_CUBE_DIM_CALC_HIER Procedure Parameters

9-10 SET_DESCRIPTION Procedure Parameters

9-11 SET_DISPLAY_NAME Procedure Parameters

9-12 SET_MV_SUMMARY_CODE Procedure Parameters

9-13 SET_SHORT_DESCRIPTION Procedure Parameters

10-1 CWM2_OLAP_DELETE

10-2 DELETE_CUBE Procedure Parameters

10-3 DELETE_DIMENSION Procedure Parameters

10-4 DELETE_MEASURE_CATALOG Procedure Parameters

10-5 DELETE_OLAP_CATALOG Procedure Parameters

11-1 CWM2_OLAP_DIMENSION Subprograms

11-2 CREATE_DIMENSION Procedure Parameters

11-3 DROP_DIMENSION Procedure Parameters

11-4 LOCK_DIMENSION Procedure Parameters

11-5 SET_DEFAULT_DISPLAY_HIERARCHY Procedure Parameters

11-6 SET_DESCRIPTION Procedure Parameters

11-7 SET_DIMENSION_NAME Procedure Parameters

11-8 SET_DISPLAY_NAME Procedure Parameters

11-9 SET_PLURAL_NAME Procedure Parameters

11-10 SET_SHORT_DESCRIPTION Procedure Parameters

12-1 Reserved Dimension Attributes

12-2 CWM2_OLAP_DIMENSION_ATTRIBUTE Subprograms

12-3 CREATE_DIMENSION_ATTRIBUTE Procedure Parameters

12-4 DROP_DIMENSION_ATTRIBUTE Procedure Parameters

12-5 LOCK_DIMENSION_ATTRIBUTE Procedure Parameters

12-6 SET_DESCRIPTION Procedure Parameters

12-7 SET_DIMENSION__ATTRIBUTE_NAME Procedure Parameters

12-8 SET_DISPLAY_NAME Procedure Parameters

12-9 SET_SHORT_DESCRIPTION Procedure Parameters

13-1 CWM2_OLAP_DELETE

13-2 EXPORT_CUBE Procedure Parameters

13-3 EXPORT_DIMENSION Procedure Parameters

13-4 EXPORT_OLAP_CATALOG Procedure Parameters

14-1 CWM2_OLAP_HIERARCHY Subprograms

14-2 CREATE_HIERARCHY Procedure Parameters

14-3 DROP_HIERARCHY Procedure Parameters

14-4 LOCK_HIERARCHY Procedure Parameters

14-5 SET_DESCRIPTION Procedure Parameters

14-6 SET_DISPLAY_NAME Procedure Parameters

14-7 SET_HIERARCHY_NAME Procedure Parameters

14-8 SET_SHORT_DESCRIPTION Procedure Parameters

14-9 SET_SOLVED_CODE Procedure Parameters

15-1 CWM2_OLAP_LEVEL Subprograms

15-2 ADD_LEVEL_TO_HIERARCHY Procedure Parameters

15-3 CREATE_LEVEL Procedure Parameters

15-4 DROP_LEVEL Procedure Parameters

15-5 LOCK_LEVEL Procedure Parameters

15-6 REMOVE_LEVEL_FROM_HIERARCHY Procedure Parameters

15-7 SET_DESCRIPTION Procedure Parameters

15-8 SET_DISPLAY_NAME Procedure Parameters

15-9 SET_LEVEL_NAME Procedure Parameters

15-10 SET_PLURAL_NAME Procedure Parameters

15-11 SET_SHORT_DESCRIPTION Procedure Parameters

16-1 Reserved Level Attributes

16-2 CWM2_OLAP_LEVEL_ATTRIBUTE Subprograms

16-3 CREATE_LEVEL_ATTRIBUTE Procedure Parameters

16-4 DROP_LEVEL_ATTRIBUTE Procedure Parameters

16-5 LOCK_LEVEL_ATTRIBUTE Procedure Parameters

16-6 SET_DESCRIPTION Procedure Parameters

16-7 SET_DISPLAY_NAME Procedure Parameters

16-8 SET_LEVEL_ATTRIBUTE_NAME Procedure Parameters

16-9 SET_SHORT_DESCRIPTION Procedure Parameters

17-1 CWM2_OLAP_MANAGER

17-2 BEGIN_LOG Procedure Parameters

17-3 LOG_NOTE Procedure Parameters

18-1 CWM2_OLAP_MEASURE Subprograms

18-2 CREATE_MEASURE Procedure Parameters

18-3 DROP_MEASURE Procedure Parameters

18-4 LOCK_MEASURE Procedure Parameters

18-5 SET_DESCRIPTION Procedure Parameters

18-6 SET_DISPLAY_NAME Procedure Parameters

18-7 SET_MEASURE_NAME Procedure Parameters

18-8 SET_SHORT_DESCRIPTION Procedure Parameters

19-1 CWM2_OLAP_METADATA_REFRESH Subprograms

20-1 CWM2_OLAP_PC_TRANSFORM

20-2 CREATE_SCRIPT Procedure Parameters

21-1 CWM2_OLAP_TABLE_MAP

21-2 MAP_DIMTBL_HIERLEVELATTR Procedure Parameters

21-3 MAP_DIMTBL_HIERLEVEL Procedure Parameters

21-4 MAP_DIMTBL_HIERSORTKEY Procedure Parameters

21-5 MAP_DIMTBL_LEVELATTR Procedure Parameters

21-6 MAP_DIMTBL_LEVEL Procedure Parameters

21-7 MAP_FACTTBL_LEVELKEY Procedure Parameters

21-8 MAP_FACTTBL_MEASURE Procedure Parameters

21-9 REMOVEMAP_DIMTBL_HIERLEVELATTR Procedure Parameters

21-10 REMOVEMAP_DIMTBL_HIERLEVEL Procedure Parameters

21-11 REMOVEMAP_DIMTBL_HIERSORTKEY Procedure Parameters

21-12 REMOVEMAP_DIMTBL_LEVELATTR Procedure Parameters

21-13 REMOVEMAP_DIMTBL_LEVEL Procedure Parameters

21-14 REMOVEMAP_FACTTBL_LEVELKEY Procedure Parameters

21-15 REMOVEMAP_FACTTBL_MEASURE Procedure Parameters

22-1 CWM2_OLAP_VALIDATE

22-2 VALIDATE_ALL_CUBES Procedure Parameters

22-3 VALIDATE_ALL_DIMENSIONS Procedure Parameters

22-4 VALIDATE_CUBE Procedure Parameters

22-5 VALIDATE_DIMENSION Procedure Parameters

22-6 VALIDATE_OLAP_CATALOG Procedure Parameters

23-1 CWM2_OLAP_VERIFY_ACCESS

23-2 VERIFY_CUBE_ACCESS Procedure Parameters

24-1 DBMS_AW Subprograms

24-2 ADD_DIMENSION_SOURCE Procedure Parameters

24-3 ADVISE_CUBE Procedure Parameters

24-4 ADVISE_DIMENSIONALITY Function Parameters

24-5 ADVISE_DIMENSIONALITY Procedure Parameters

24-6 ADVISE_REL Procedure Parameters

24-7 ADVISE_SPARSITY Procedure Parameters

24-8 Output Column Descriptions

24-9 AW_ATTACH Procedure Parameters

24-10 AW_COPY Procedure Parameters

24-11 AW_CREATE Procedure Parameters

24-12 AW_DELETE Procedure Parameters

24-13 AW_DETACH Procedure Parameters

24-14 AW_RENAME Procedure Parameters

24-15 AW_TABLESPACE Function Parameters

24-16 AW_UPDATE Procedure Parameters

24-17 CONVERT Procedure Parameters

24-18 EVAL_NUMBER Function Parameters

24-19 EVAL_TEXT Function Parameters

24-20 EXECUTE Procedure Parameters

24-21 INFILE Procedure Parameters

24-22 INTERP Function Parameters

24-23 INTERPCLOB Function Parameters

24-24 INTERP_SILENT Function Parameters

24-25 PRINTLOG Procedure Parameters

24-26 EXECUTE Procedure Parameters

24-27 SHUTDOWN Procedure Parameters

24-28 SPARSITY_ADVICE_TABLE Procedure Parameters

25-1 DBMS_AW_XML Subprograms

25-2 EXECUTE Function Parameters

25-3 EXECUTEFILE Function Parameters

26-1 Parameters of DBMS_AWM Procedures

26-2 DBMS_AWM Subprograms

26-3 ADD_AWCOMP_SPEC_COMP_MEMBER Procedure Parameters

26-4 ADD_AWCOMP_SPEC_MEMBER Procedure Parameters

26-5 ADD_AWCUBEAGG_SPEC_LEVEL Procedure Parameters

26-6 ADD_AWCUBEAGG_SPEC_MEASURE Procedure Parameters

26-7 ADD_AWCUBELOAD_SPEC_COMP Procedure Parameters

26-8 ADD_AWCUBELOAD_SPEC_FILTER Procedure Parameters

26-9 ADD_AWCUBELOAD_SPEC_MEASURE Procedure Parameters

26-10 ADD_AWDIMLOAD_SPEC_FILTER Procedure Parameters

26-11 AGGREGATE_AWCUBE Procedure Parameters

26-12 CREATE_AWCOMP_SPEC Procedure Parameters

26-13 CREATE_AWCUBE Procedure Parameters

26-14 CREATE_AWCUBE_ACCESS Procedure Parameters

26-15 CREATE_AWCUBE_ACCESS_FULL Procedure Parameters

26-16 CREATE_AWCUBEAGG_SPEC Procedure Parameters

26-17 CREATE_AWCUBELOAD_SPEC Procedure Parameters

26-18 CREATE_AWDIMENSION Procedure Parameters

26-19 CREATE_AWDIMENSION_ACCESS Procedure Parameters

26-20 CREATE_AWDIMENSION_ACCESS_FULL Procedure Parameters

26-21 CREATE_AWDIMLOAD_SPEC Procedure Parameters

26-22 CREATE_DYNAMIC_AW_ACCESS Procedure Parameters

26-23 DELETE_AWCOMP_SPEC Procedure Parameters

26-24 DELETE_AWCOMP_SPEC_MEMBER Procedure Parameters

26-25 DELETE_AWCUBE_ACCESS Procedure Parameters

26-26 DELETE_AWCUBE_ACCESS_ALL Procedure Parameters

26-27 DELETE_AWCUBEAGG_SPEC Procedure Parameters

26-28 DELETE_AWCUBEAGG_SPEC_LEVEL Procedure Parameters

26-29 DELETE_AWCUBEAGG_SPEC_MEASURE Procedure Parameters

26-30 DELETE_AWCUBELOAD_SPEC Procedure Parameters

26-31 DELETE_AWCUBELOAD_SPEC_COMP Procedure Parameters

26-32 DELETE_AWCUBELOAD_SPEC_FILTER Procedure Parameters

26-33 DELETE_AWCUBELOAD_SPEC_MEASURE Procedure Parameters

26-34 DELETE_AWDIMENSION_ACCESS Procedure Parameters

26-35 DELETE_AWDIMENSION_ACCESS_ALL Procedure Parameters

26-36 DELETE_AWDIMLOAD_SPEC Procedure Parameters

26-37 DELETE_AWDIMLOAD_SPEC_FILTER Procedure Parameters

26-38 REFRESH_AWCUBE Procedure Parameters

26-39 REFRESH_AWCUBE_VIEW_NAME Procedure Parameters

26-40 REFRESH_AWDIMENSION Procedure Parameters

26-41 REFRESH_AWDIMENSION_VIEW_NAME Procedure Parameters

26-42 SET_AWCOMP_SPEC_CUBE Procedure Parameters

26-43 SET_AWCOMP_SPEC_MEMBER_NAME Procedure Parameters

26-44 SET_AWCOMP_SPEC_MEMBER_POS Procedure Parameters

26-45 SET_AWCOMP_SPEC_MEMBER_SEG Procedure Parameters

26-46 SET_AWCOMP_SPEC_NAME Procedure Parameters

26-47 SET_AWCUBE_VIEW_NAME Procedure Parameters

26-48 SET_AWCUBEAGG_SPEC_AGGOP Procedure Parameters

26-49 SET_AWCUBELOAD_SPEC_CUBE Procedure Parameters

26-50 SET_AWCUBELOAD_SPEC_LOADTYPE Procedure Parameters

26-51 SET_AWCUBELOAD_SPEC_NAME Procedure Parameters

26-52 SET_AWCUBELOAD_SPEC_PARAMETER Procedure Parameters

26-53 SET_AWDIMENSION_VIEW_NAME Procedure Parameters

26-54 SET_AWDIMLOAD_SPEC_DIMENSION Procedure Parameters

26-55 SET_AWDIMLOAD_SPEC_LOADTYPE Procedure Parameters

26-56 SET_AWDIMLOAD_SPEC_NAME Procedure Parameters

26-57 SET_AWDIMLOAD_SPEC_PARAMETER Procedure Parameters

26-58 UPGRADE_AW_TO_10_2 Parameters

27-1 Dimensions of GLOBAL.UNITS_CUBE

27-2 Minimum Grouping Sets for Units Cube

27-3 DBMS_ODM Subprograms

27-4 CREATECUBELEVELTUPLE Procedure Parameters

27-5 CREATEDIMLEVTUPLE Procedure Parameters

27-6 CREATEDIMMV_GS Procedure Parameters

27-7 CREATEFACTMV_GS Procedure Parameters

27-8 CREATESTDFACTMV Procedure Parameters

28-1 ALL_OLAP_ALTER_SESSION Column Descriptions

28-2 OLAP_API_SESSION_INIT Subprograms

28-3 ADD_ALTER_SESSION Procedure Parameters

28-4 DELETE_ALTER_SESSION Procedure Parameters

29-1 OLAP_CONDITION Function Parameters

29-2 Entry Points for OLAP_CONDITION in the OLAP_TABLE Limit Map

30-1 OLAP_EXPRESSION Function Parameters

31-1 OLAP_EXPRESSION_BOOL Function Parameters

32-1 OLAP_EXPRESSION_DATE Function Parameters

33-1 OLAP_EXPRESSION_TEXT Function Parameters

34-1 Default Data Type Conversions

34-2 OLAP_TABLE Function Parameters