CREATE_LEVEL_ATTRIBUTE

This procedure registers a new level attribute as an entity in the OLAP 2 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.

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 21-2 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 21-3 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	The parent dimension does not exist within the OLAP 2 Catalog.
dimension_attribute_not_found	The parent dimension attribute does not exist for this dimension.
level_not_found	The parent level does not exist for this dimension.
level_attribute_already_exists	This level attribute already exists for this level.