OBIEE 188.8.131.52: EssBase: When using Selection Steps and Expanding the Hierarchy, Other Parts of the Hierarchy also Expand Unexpectedly
Last updated on MAY 15, 2017
Applies to:Business Intelligence Suite Enterprise Edition - Version 184.108.40.206.0 to 220.127.116.11.170418 [Release 11g to 12g]
Information in this document applies to any platform.
On : 18.104.22.168.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.
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