CWM2_OLAP_HIERARCHY , 4 of 12

CREATE_HIERARCHY Procedure

This procedure creates a new hierarchy in the OLAP Catalog.

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

Syntax

CREATE_HIERARCHY (
          dimension_owner       IN   VARCHAR2,
          dimension_name        IN   VARCHAR2,
          hierarchy_name        IN   VARCHAR2,
          display_name          IN   VARCHAR2,
          short_description     IN   VARCHAR2,
          description           IN   VARCHAR2,
          solved_code           IN   VARCHAR2);

Parameters

Table 20-2 CREATE_HIERARCHY Procedure Parameters

Parameter	Description
`dimension_owner`	Owner of the dimension.
`dimension_name`	Name of the dimension.
`hierarchy_name`	Name of the hierarchy.
`display_name`	Display name for the hierarchy.
`short_description`	Short description of the hierarchy.
`description`	Description of the hierarchy.
`solved_code`	Specifies whether or not the hierarchy includes embedded totals and whether it is mapped to a level-based dimension table or a parent-child dimension table. For information about mapping hierarchies with different solved codes, see "Joining Fact Tables with Dimension Tables". Values for this parameter are: `UNSOLVED LEVEL-BASED,` for a hierarchy that contains no embedded totals and is stored in a level-based dimension table `SOLVED LEVEL-BASED,` for a hierarchy that contains embedded totals, has a grouping ID, and is stored in a level-based dimension table `SOLVED VALUE-BASED,` for a hierarchy that contains embedded totals and is stored in a parent-child dimension table

Exceptions

Table 20-3 CREATE_HIERARCHY Procedure Exceptions

Exception	Description
`no_access_privileges`	User does not have the necessary privileges. User must be the dimension owner and have the `OLAP_DBA` role.
`dimension_not_found`	Parent dimension not found.
`hierarchy_already_exists`	This hierarchy already exists for this dimension.