CWM2_OLAP_HIERARCHY , 11 of 12

SET_SOLVED_CODE Procedure

This procedure sets the solved code for a hierarchy. The solved code specifies whether or not the data dimensioned by this hierarchy includes embedded totals and whether it is mapped to a level-based dimension table or a parent-child dimension table. If mapped to a parent-child dimension table, it cannot be accessed by the OLAP API.

For more information on mapping solved and unsolved data, see "Joining Fact Tables with Dimension Tables".

Syntax

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

Parameters

Table 20-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. This type of hierarchy cannot be accessed by the OLAP API.

Exceptions

Table 20-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`	Parent dimension not found.
`hierarchy_not_found`	Hierarchy not found.