Skip Headers

Oracle9i OLAP User's Guide
Release 2 (9.2.0.2)

Part Number A95295-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page Go to next page
View PDF

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 17-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 17-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

Cube not found.

dimension_not_found

Dimension not found.