CWM2_OLAP_LEVEL_ATTRIBUTE , 9 of 11

SET_LEVEL_ATTRIBUTE_NAME Procedure

This procedure sets the name for a level attribute.

For information on reserved level attribute names, see Table 22-1, " Reserved Level Attributes".

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 22-13 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 22-14 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`	Parent dimension not found.
`dimension_attribute_not_found`	Parent dimension attribute not found.
`level_not_found`	Parent level not found.
`level_attribute_not_found`	Level attribute not found.