ADD_DIMENSION_TO_CUBE Procedure

This procedure adds a dimension to a cube.

Syntax

ADD_DIMENSION_TO_CUBE  (
          cube_owner         IN   VARCHAR2,
          cube_name          IN   VARCHAR2,
          dimension_owner    IN   VARCHAR2,
          dimension_name     IN   VARCHAR2);

Parameters

Table 22-2 ADD_DIMENSION_TO_CUBE Procedure Parameters

Parameter	Description
cube_owner	Owner of the cube.
cube_name	Name of the cube.
dimension_owner	Owner of the dimension to be added to the cube.
dimension_name	Name of the dimension to be added to the cube.

Exceptions

Table 22-3 ADD_DIMENSION_TO_CUBE 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	Cannot update cube. Cube does not exist within the OLAP 2 Catalog.
dimension_not_found	Dimension does not exist or is not accessible within the OLAP 2 Catalog.