OBIEE 184.108.40.206: EssBase: When using Selection Steps and Expanding the Hierarchy, Other Parts of the Hierarchy also Expand Unexpectedly
(Doc ID 2263725.1)
Last updated on FEBRUARY 03, 2019
Applies to:Business Intelligence Suite Enterprise Edition - Version 220.127.116.11.0 to 18.104.22.168.170418 [Release 11g to 12g]
Information in this document applies to any platform.
On : 22.214.171.124.0 version and later
When you used Essbase as the data source and set selection step in hierarchy, expanding dimension members will be linked to other members unexpectedly.
For example,in Analysis, create a simple report and set Selection Step in Hierarchy. Like below:
1. Use 'Products Hierarchy' to create a report.
2. In Result tab, add a selection step with 'Select Members based on Hierarchy' to Keep all members of: Gen1,Product; Gen2,Product; Gen3,Product; Gen4,Product; Gen5,Product levels.
3. Add a selection step on 'Products Hierarchy' to REMOVE one of the member 'THUNDERBALL'.
4. When expanding the hierarchy of 'LIGHTBOLT', the members of the other hierarchy are expanding too.
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