SET_DEFAULT_CUBE_DIM_CALC_HIER Procedure

This procedure sets the default calculation hierarchy for a dimension of this cube.

Syntax

SET_DEFAULT_CUBE_DIM_CALC_HIER (
          cube_owner       IN   VARCHAR2,
          cube_name        IN   VARCHAR2,
          dimension_owner   IN  VARCHAR2,
          dimension_name    IN   VARCHAR2,
          hierarchy_name   IN   VARCHAR2);

Parameters

Table 22-14 SET_DEFAULT_CUBE_DIM_CALC_HIER Procedure Parameters

Parameter	Description
cube_owner	Owner of the cube.
cube_owner	Name of the cube.
dimension_owner	Owner of the dimension.
dimension_name	Name of the dimension.
hierarchy_name	Name of the hierarchy to be used by default for this dimension.

Exceptions

Table 22-15 SET_DEFAULT_CUBE_DIM_CALC_HIER 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.
cube_not_found	Cannot update cube. Cube does not exist within the OLAP 2 Catalog.