SET_HIERARCHY_NAME Procedure

This procedure sets the name for a hierarchy.

Syntax

SET_HIERARCHY_NAME (
          dimension_owner        IN   VARCHAR2,
          dimension_name         IN   VARCHAR2,
          hierarchy_name         IN   VARCHAR2,
          set_hierarchy_name     IN   VARCHAR2);

Parameters

Table 20-12  SET_HIERARCHY_NAME Procedure Parameters

Parameter	Description
dimension_owner	Owner of the dimension.
dimension_name	Name of the dimension.
hierarchy_name	Original name for the hierarchy.
set_hierarchy_name	New name for the hierarchy.

Exceptions

Table 20-13  SET_HIERARCHY_NAME 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_not_found	Hierarchy not found.