DROP_MEASURE Procedure

This procedure drops a measure from a cube.

Syntax

DROP_MEASURE (
         cube_owner      IN   VARCHAR2,
         cube_name        IN   VARCHAR2,
         measure_name    IN   VARCHAR2);

Parameters

Table 23-4  DROP_MEASURE Procedure Parameters

Parameter	Description
cube_owner	Owner of the cube.
cube_name	Name of the cube.
measure_name	Name of the measure to be dropped from the cube.

Exceptions

Table 23-5  DROP_MEASURE 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.
cube_not_found	Parent cube not found.
measure_not_found	Measure not found.