CWM2_OLAP_LEVEL_ATTRIBUTE , 4 of 11

CREATE_LEVEL_ATTRIBUTE

This procedure creates a new level attribute in the OLAP Catalog and associates the level attribute with a level and with a dimension attribute.

If the level attribute name should be reserved for a specific level and dimension attribute combination, you can set the RESERVED_LEVEL_ATTRIBUTE argument to TRUE. For more information, see Table 22-1, " Reserved Level Attributes".

You must specify descriptions and display properties as part of level attribute creation. Once the level attribute has been created, you can override these properties by calling other procedures in the CWM2_OLAP_LEVEL_ATTRIBUTE package.

Syntax

CREATE_LEVEL_ATTRIBUTE (
          dimension_owner            IN   VARCHAR2,
          dimension_name             IN   VARCHAR2,
          dimension_attribute_name   IN   VARCHAR2,
          level_name                 IN   VARCHAR2,
          level_attribute_name       IN   VARCHAR2,
          display_name               IN   VARCHAR2,
          short_description          IN   VARCHAR2,
          description                IN   VARCHAR2,
          reserved_level_attribute   IN   BOOLEAN  FALSE);

Parameters

Table 22-3 CREATE_LEVEL_ATTRIBUTE Procedure Parameters

Parameter	Description
`dimension_owner`	Owner of the dimension.
`dimension_name`	Name of the dimension.
`dimension_attribute_name`	Name of the dimension attribute that includes this level attribute.
`level_name`	Name of the level.
`level_attribute_name`	Name of the level attribute.
`display_name`	Display name for the level attribute.
`short_description`	Short description of the level attribute.
`description`	Description of the level attribute.
`reserved_level_attribute`	Whether or not this level attribute is reserved. By default, the level attribute is not reserved. The reserved level attributes are as follows. Long Description Short Description End Date Time Span Prior Period Year Ago Period ET Key Parent ET Key Grouping ID Parent Grouping ID

Exceptions

Table 22-4 CREATE_LEVEL_ATTRIBUTE 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_already_exists	This level attribute already exists for this level.