Understanding the DBMS_AWM Procedures

The procedures in the DBMS_AWM package support methods on several types of logical entities. These entities are described in Table 1-1.

Entity	Description
Dimension	A dimension in the OLAP Catalog and its corresponding dimension in an analytic workspace.
Cube	A cube in the OLAP Catalog and its corresponding cube in an analytic workspace.
Dimension Load Specification	Instructions for populating an analytic workspace dimension from the dimension tables of an OLAP Catalog dimension.
Cube Load Specification	Instructions for populating an analytic workspace cube from the fact table of an OLAP Catalog cube.
Cube Aggregation Specification	Instructions for creating summary data in an analytic workspace.
Cube Composite Specification	Instructions for ordering dimensions and storing sparse data in an analytic workspace.

Methods on Dimensions

The methods you can perform on a dimension are described in Table 1-2.

Table 1-2 Methods on Dimensions in DBMS_AWM

Method	Description	Procedure
Create	Create the metadata in an analytic workspace for a dimension defined in the OLAP Catalog.	CREATE_AWDIMENSION Procedure
Refresh	Use a dimension load specification to populate an analytic workspace dimension from the dimension tables of an OLAP Catalog dimension.	REFRESH_AWDIMENSION Procedure
Enable for non-OLAP clients	Create a script to enable relational access to a dimension in an analytic workspace.	CREATE_AWDIMENSION_ACCESS Procedure
	Create a script to disable relational access to a dimension in an analytic workspace.	DELETE_AWDIMENSION_ACCESS Procedure
	Create and run a script to enable relational access to a dimension in an analytic workspace	CREATE_AWDIMENSION_ACCESS_FULL Procedure
	Create and run a script to disable relational access to a dimension in an analytic workspace.	DELETE_AWDIMENSION_ACCESS_ALL Procedure
	Refresh the workspace metadata that supports user-defined view names for a dimension in an analytic workspace.	REFRESH_AWDIMENSION_VIEW_NAME Procedure
	Specify names for the relational views of a dimension in an analytic workspace.	SET_AWDIMENSION_VIEW_NAME Procedure

The methods you can perform on a cube are described in Table 1-3.

Table 1-3 Methods on Cubes in DBMS_AWM

Method	Description	Procedure
Create	Create containers in an analytic workspace for a cube defined in the OLAP Catalog.	CREATE_AWCUBE Procedure
Refresh	Use a cube load specification to populate the measures of an analytic workspace cube from the fact table of an OLAP Catalog cube.	REFRESH_AWCUBE Procedure
Aggregate	Use an aggregation specification to aggregate the cube in the analytic workspace.	AGGREGATE_AWCUBE Procedure
Enable for non-OLAP clients	Create a script to enable relational access to a cube in an analytic workspace.	CREATE_AWCUBE_ACCESS Procedure
	Create a script to disable relational access to a cube in an analytic workspace	DELETE_AWCUBE_ACCESS Procedure
	Create and run a script to enable relational access to a cube in an analytic workspace.	CREATE_AWCUBE_ACCESS_FULL Procedure
	Create and run a script to disable relational access to a cube in an analytic workspace.	DELETE_AWCUBE_ACCESS_ALL Procedure
	Refresh the workspace metadata that supports user-defined view names for a cube in an analytic workspace.	REFRESH_AWCUBE_VIEW_NAME Procedure
	Specify names for the relational views of a cube in an analytic workspace.	SET_AWCUBE_VIEW_NAME Procedure

The methods you can perform on a dimension load specification are described in Table 1-4.

Table 1-4 Methods on Dimension Load Specifications in DBMS_AWM

Method	Description	Procedure
Create/Delete	Create or delete a dimension load specification.	CREATE_AWDIMLOAD_SPEC Procedure DELETE_AWDIMLOAD_SPEC Procedure
Reset information	Change various components of a dimension load specification.	SET_AWDIMLOAD_SPEC_DIMENSION Procedure SET_AWDIMLOAD_SPEC_LOADTYPE Procedure SET_AWDIMLOAD_SPEC_NAME Procedure SET_AWDIMLOAD_SPEC_PARAMETER Procedure
Add/Delete filter	Add or remove a filter from a dimension load specification.	ADD_AWDIMLOAD_SPEC_FILTER Procedure DELETE_AWDIMLOAD_SPEC_FILTER Procedure

Method

Description

Procedure

Create/Delete

Create or delete a dimension load specification.

Reset information

Change various components of a dimension load specification.

Add/Delete filter

Add or remove a filter from a dimension load specification.

The methods you can perform on a cube load specification are described in Table 1-5.

Table 1-5 Methods on Cube Load Specifications in DBMS_AWM

Method	Description	Procedure
Create/Delete	Create or delete a cube load specification.	CREATE_AWCUBELOAD_SPEC Procedure DELETE_AWCUBELOAD_SPEC Procedure
Reset information	Change various components of a cube load specification.	SET_AWCUBELOAD_SPEC_CUBE Procedure SET_AWCUBELOAD_SPEC_LOADTYPE Procedure SET_AWCUBELOAD_SPEC_NAME Procedure SET_AWCUBELOAD_SPEC_PARAMETER Procedure
Add/Delete filter	Add or remove a filter from a cube load specification.	ADD_AWCUBELOAD_SPEC_FILTER Procedure DELETE_AWCUBELOAD_SPEC_FILTER Procedure
Add/Delete composite specification	Add or remove a composite specification from a cube load specification.	ADD_AWCUBELOAD_SPEC_COMP Procedure DELETE_AWCUBELOAD_SPEC_COMP Procedure

The methods you can perform on an aggregation specification are described in Table 1-6.

Table 1-6 Methods on Aggregation Specifications in DBMS_AWM

Method	Description	Procedure
Create/Delete	Create or delete an aggregation specification.	CREATE_AWCUBEAGG_SPEC Procedure DELETE_AWCUBEAGG_SPEC_MEASURE Procedure
Set operator	Set the aggregation operator for a dimension.	SET_AWCUBEAGG_SPEC_AGGOP Procedure
Add/Delete levels	Add or remove levels from an aggregation specification.	ADD_AWCUBEAGG_SPEC_LEVEL Procedure DELETE_AWCUBEAGG_SPEC_LEVEL Procedure
Add/Delete measures	Add or remove measures from an aggregation specification.	ADD_AWCUBEAGG_SPEC_MEASURE Procedure DELETE_AWCUBEAGG_SPEC_MEASURE Procedure

The methods you can perform on a composite specification are described in Table 1-7.

Table 1-7 Methods on Composite Specifications in DBMS_AWM

Method	Description	Procedure
Create/Delete	Create or delete a composite specification.	CREATE_AWCOMP_SPEC Procedure DELETE_AWCOMP_SPEC Procedure
Reset information	Change the name of the composite specification or associate it with a different cube.	SET_AWCOMP_SPEC_CUBE Procedure SET_AWCOMP_SPEC_NAME Procedure
Add/Delete members	Add or remove members from the specification. Members can be dimensions or composites.	ADD_AWCOMP_SPEC_MEMBER Procedure DELETE_AWCOMP_SPEC_MEMBER Procedure
Reset member information	Change information about members of the specification.	SET_AWCOMP_SPEC_MEMBER_NAME Procedure SET_AWCOMP_SPEC_MEMBER_POS Procedure SET_AWCOMP_SPEC_MEMBER_SEG Procedure
Add composite members	Add members to a composite in the specification.	ADD_AWCOMP_SPEC_COMP_MEMBER Procedure