CREATE_DIMENSION_ATTRIBUTE Procedure

This procedure creates a new dimension attribute.

If the dimension attribute name should be reserved for mapping specific groups of level attributes, you can set the RESERVED_DIMENSION_ATTRIBUTE argument to TRUE. For more information, see Table 19-1, " Reserved Dimension Attributes".

Descriptions and display properties must also be established as part of dimension attribute creation. Once the dimension attribute has been created, you can override these properties by calling other procedures in this package.

Syntax

CREATE_DIMENSION_ATTRIBUTE (
          dimension_owner               IN   VARCHAR2,
          dimension_name                IN   VARCHAR2,
          dimension_attribute_name      IN   VARCHAR2,
          display_name                  IN   VARCHAR2,
          short_description             IN   VARCHAR2,
          description                   IN   VARCHAR2,
          reserved_dimension_attribute  IN   BOOLEAN DEFAULT FALSE);

Parameters

Table 19-3  CREATE_DIMENSION_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.
display_name	Display name for the dimension attribute.
short_description	Short description of the dimension attribute.
description	Description of the dimension attribute.
reserved_dimension_attribute	Whether or not this is a reserved dimension attribute. By default, the dimension attribute is not reserved. The reserved dimension attributes are described in Table 19-1, " Reserved Dimension Attributes".

Exceptions

Table 19-4  CREATE_DIMENSION_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_attribute_already_exists	Dimension attribute already exists.