My Oracle Support Banner

OBIEE - Essbase Parent Child Hierarchy Setup Does Not Differentiate Between Alternate Hierarchies (Doc ID 2775574.1)

Last updated on MARCH 05, 2024

Applies to:

Oracle Exalytics T5-8 - Version All Versions and later
Business Intelligence Server Enterprise Edition - Version 12.2.1.4.0 to 12.2.1.4.201216 [Release 12g]
Information in this document applies to any platform.

Symptoms

OBIEE 12c is setup with an Essbase data source. Alternate hierarchies are setup and have been converted to alternate hierarchies as parent child dimensions after importing the cube into the repository.

Now, when trying to use the level_number property to find out all the members in a particular hierarchy with level = 0, it ignores the actual hierarchy chain that they are pulling from. 

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.