Using OBIEE 12.2.1.4
I have created a hierarchy with 4 levels.
When I expand Level 1, all of the values for Level 2 are displayed.
When I expand one of the Level 2 values, all matching level 2 values are displayed as well.
An example looks like this (everything expanded):
Total
--Region 1
----Sales Dept
------John Doe
----HR Dept
------Bob Smith
------Chris Jones
----Marketing Dept
------Arnold Port
--Region 2
----Sales Dept
------Sid Nancy
----HR Dept
------Tammy Hughes
------Frank Oslo
----Marketing Dept
------Susan Montgomery
Collapse everything and then expand Total:
Total
--Region 1
--Region 2
Expand Region 2:
Total
--Region 1
--Region 2
----Sales Dept
----HR Dept
----Marketing Dept
Expand HR Dept under Region 2
Total
--Region 1
------Bob Smith
------Chris Jones
--Region 2
----Sales Dept
----HR Dept
------Tammy Hughes
------Frank Oslo
----Marketing Dept
Notice that the HR employees for Region 1 are displayed along with HR employees under Region 2.
I expect only the Region 2 HR employees to be displayed.
Do I have something wrong with my keys?
