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_SHORT_DESCRIPTION Procedure

This procedure sets the short description for a hierarchy.

Syntax

SET_SHORT_DESCRIPTION (
          dimension_owner        IN   VARCHAR2,
          dimension_name         IN   VARCHAR2,
          hierarchy_name         IN   VARCHAR2,
          short_description      IN   VARCHAR2);

Parameters

Table 20-14  SET_SHORT_DESCRIPTION Procedure Parameters
Parameter Description

dimension_owner

Owner of the dimension.

dimension_name

Name of the dimension.

hierarchy_name

Name of the hierarchy.

short_description

Short description of the hierarchy.

Exceptions

Table 20-15  SET_SHORT_DESCRIPTION Procedure Exceptions
Exception Description

no_access_privileges

User does not have the necessary privileges. User must be the dimension owner and have the OLAP_DBA role.

dimension_not_found

Parent dimension not found.

hierarchy_not_found

Hierarchy not found.