CREATE_DIMENSION_ATTRIBUTE Procedure

This procedure registers a new dimension attribute entity in the OLAP 2 Catalog.

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 18-2 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 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 18-3 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	Cannot create dimension attribute. Dimension attribute already exists in the OLAP 2 Catalog.