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

SET_DIMENSION_ATTRIBUTE_NAME Procedure

This procedure sets the name for a dimension attribute.

Syntax

SET_DIMENSION_ATTRIBUTE_NAME (
          dimension_owner                  IN   VARCHAR2,
          dimension_name                   IN   VARCHAR2,
          dimension_attribute_name         IN   VARCHAR2,
          set_dimension_attribute_name     IN   VARCHAR2,
          reserved_dimension_attribute     IN   BOOLEAN DEFAULT FALSE);

Parameters

Table 19-11  SET_DIMENSION__ATTRIBUTE_NAME Procedure Parameters
Parameter Description

dimension_owner

Owner of the dimension.

dimension_name

Name of the dimension.

dimension_attribute_name

Original name for the dimension attribute.

set_dimension_attribute_name

New name for the dimension attribute.

reserved_dimension_attribute

Whether or not this is a reserved dimension attribute. By default, the dimension attribute is not reserved.

Exceptions

Table 19-12  SET_DIMENSION_ATTRIBUTE_NAME 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

Parent dimension not found.

dimension_attribute_not_found

Dimension attribute not found.