Multiple Value-Based Hierarchies Overwrite Each Other (Doc ID 1362749.1)

Last updated on SEPTEMBER 28, 2011

Applies to:

Oracle OLAP - Version: 11.2.0.1 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Goal


=== ODM Question ===

When creating multiple value-based hierarchies for a dimension, the first hierarchy is created correctly but any additional hierarchies change the previous one(s). This occurs whether hierarchies are created in OWB 11g or AWM 11g.


Example:

Hierarchy Table Sources

DIM1_P_V

DIMVAL PARENT

D1 (null)
D10 D1
D100 D10
D200 D10

DIM_P1_V

D2 (null)
D20 D2
D100 D20
D200 D20

Mapping in AWM shows DIM1_P1_V mapped to DIM_3 Hierarchies Parent and Parent1 correctly.
When viewing the hierarchies the following is seen.

Parent (INCORRECT VALUES)

'dim_3' Dimension Members:
D1
D10
D100
D200

and

Parent1 (CORRECT VALUES)

D2
D100
D200

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms