I have a scenario in which I’m trying to avoid using ‘unions’ using OBIEE 12c.
I also have a simple Hour listbox dashboard prompt with up to 24 selections:
Description automatically generated with medium confidence
When I select certain hours, I get the following result:
Description automatically generated with low confidence
My customer wants to group hourly data in up to 4 separate groups: Hour Grp A, Hour Grp B, Hour Grp C, Hour Grp D.
Each grouping can have up to 24 selections. Here is an example Hour Group listbox dashboard prompt:
Description automatically generated with low confidence
And this is what it looks like after I apply the filter:
Description automatically generated
This result was accomplish via ‘unions’.
Let me know if I can clarify anything. As I first mentioned, I would like to accomplish this without using ‘unions’ in my analysis.