SET_SOLVED_CODE Procedure

This procedure sets the solved code for a hierarchy. The 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.

Syntax

SET_SOLVED_CODE (
          dimension_owner     IN   VARCHAR2,
          dimension_name      IN   VARCHAR2,
          hierarchy_name      IN   VARCHAR2,
          solved_code         IN   VARCHAR2);

Parameters

Table 19-16 SET_SOLVED_CODE Procedure Parameters

Parameter	Description
dimension_owner	Owner of the dimension.
dimension_name	Name of the dimension.
hierarchy_name	Name of the hierarchy.
solved_code	One of the following values: UNSOLVED LEVEL, for a hierarchy that contains no embedded totals and is stored in a level-based dimension table SOLVED LEVEL, for a hierarchy that contains embedded totals, has a grouping ID, and is stored in a level-based dimension table SOLVED VALUE, for a hierarchy that contains embedded totals and is stored in a parent/child dimension table

Exceptions

Table 19-17 SET_SOLVED_CODE 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	The parent dimension does not exist within the OLAP 2 Catalog.
hierarchy_not_found	This hierarchy does not exist for this dimension.