SET_LEVEL_ATTRIBUTE_NAME Procedure

This procedure sets the name for a level attribute.

Syntax

SET_LEVEL_ATTRIBUTE_NAME (
          dimension_owner             IN   VARCHAR2,
          dimension_name              IN   VARCHAR2,
          dimension_attribute_name    IN   VARCHAR2,
          level_name                  IN   VARCHAR2,
          level_attribute_name        IN   VARCHAR2,
          set_level_attribute_name    IN   VARCHAR2,
          reserved_level_attribute    IN   BOOLEAN DEFAULT FALSE);

Parameters

Table 21-12 SET_LEVEL_ATTRIBUTE_NAME Procedure Parameters

Parameter	Description
dimension_owner	Owner of the dimension.
dimension_name	Name of the dimension.
dimension_attribute_name	Name of the dimension attribute.
level_name	Name for the level.
level_attribute_name	Original name for the level attribute.
set_level_attribute_name	New name for the level attribute.
reserved_level_attribute	Whether or not this level attribute is reserved. By default, the level attribute is not reserved.

Exceptions

Table 21-13 SET_LEVEL_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	The parent dimension does not exist within the OLAP 2 Catalog.
dimension_attribute_not_found	This dimension attribute does not exist for this dimension.
level_not_found	This level does not exist for this dimension.
level_attribute_not_found	This level attribute does not exist for this dimension attribute and level combination.