DROP_DIMENSION Procedure

This procedure drops a dimension from the OLAP 2 Catalog. All related levels, hierarchies, and dimension attributes are also dropped.

Syntax

DROP_DIMENSION (
         dimension_owner     IN   VARCHAR2,
         dimension_name      IN   VARCHAR2);

Parameters

Table 17-5 DROP_DIMENSION Procedure Parameters

Parameter	Description
dimension_owner	Owner of the dimension.
dimension_name	Name of the dimension.

Exceptions

Table 17-6 DROP_DIMENSION Procedure Exceptions

Exception	Description
no_access_privileges	User does not have the necessary privileges. User must be the owner and have the OLAP_DBA role.
dimension_not_found	Cannot drop dimension. Dimension does not exist within the OLAP 2 Catalog.