OBIEE 11g - how to pass full context when navigating from bubble chart
I am trying to enable navigation (Action Link 'Navigate to BI Content') from a bubble chart to a table, but it is not behaving as expected. I figured out that (somewhat counterintuitively, IMO) the dimension used in the 'Bubbles' section is what needs to carry the Action Link. Why it isn't the 'Bubble Size' measure is beyond me, especially considering the 'Bubbles' dimension is optional.
And but so anyway, by placing the navigation interaction on the Bubbles dimension I am able to get to the detail report, however the full context of the bubble is not passed - only the value from the Bubbles dimension. Specifically, the 'Bubble Color' dimension is not passed along. This behavior is unlike other charts, in my experience.
Here is how the source and target reports are set up:
Source (Bubble Chart):
Horizontal Axis: Measure H - no interaction on this column
Vertical Axis: Measure V - no interaction on this column
Bubble Size: Measure B - no interaction on this column
Bubbles: Director - Navigate action on this column
Vary Color By: Department - no interaction on this column
Report Filter: YearMonth=201601
There are multiple Directors in each Department, resulting in a few blue bubbles, a few green bubbles, etc.
Target (Table):
Dimensions: Department, Director
Measures: H, V, B, and X (some random other measure)
Report Filter: YearMonth Is Prompted, Director Is Prompted, Department Is Prompted
When I click on, for example, the bubble for Director "Smith" in Department "Sales", the target table comes up with filters (Director="Smith" and YearMonth=201601). Since we have multiple Smiths, the results do not tie to the bubble, which had the context (Department=Sales, Director=Smith).
The only workaround I've found is to concatenate the contextual dimensions (e.g. Department || ' - ' || Director) and put the combined column into the Bubbles area of the chart design. I then must put an Is Prompted filter on the target report for this combined column. Although this works, it results in hard-to-read mouse-over info on the bubbles. The users see:
Department: Sales
Director: Sales - Smith
H: 123
V: 456
B: 789
So is there something I'm missing here? Other charts and table navigations send the full context of the item clicked (and usually it's a measure, not a dimension, that carries the navigation). Is there a way to make bubble charts behave in the same manner?