Categories
- All Categories
- 137 Oracle Analytics News
- 24 Oracle Analytics Videos
- 14.6K Oracle Analytics Forums
- 5.6K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 52 Oracle Analytics Trainings
- 9 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
OBIEE - grouping columns
Hello all,
I have a drop down list to filter a pivot table based on types of products. I was able to group 2 values together (electronics & cellphones) and named it "XYZ", but when checking my drop down list, it adds "XYZ" and still has the 2 values I grouped together. Is there a way to remove the 2 values so that it just shows "XYZ"?
Thank you all.
Answers
-
Can you show us what you did (screenshots) and your problem ? Also please add your OBIEE version.
0 -
Did you try a calculated item instead of group?
The calculated item has an option to hide the calculated item members, so you don't have things in double.
In the example of the screenshot "Audio&Camera" will be added to the list of items in the "Product Type" column and because I checked the checkbox to remove items "Audio" and "Camera" will be removed.
0 -
Hi,
I think you can write a case statement in the column formula itself like
CASE WHEN PRODUCTS IN ('electronics','cellphones') THEN 'XYZ'
ELSE PRODUCTS
END
Hope this helps..
Regards,
Yaswanth
0 -
Gianni, thank you for your helpful answer. This is exactly what I was looking for! One last thing - I have a master child detail detail so that when you click "XYZ" it will show the users buying that product, it doesn't seem to be working and I'm assuming it is due to the newly calculated item, is there a way around this so that the master child detail works properly?
Much appreciated for your help!
0 -
Well, it just works on the calculated item, of course you must have the same calculated item on the "detail" analysis.
As I have a little doubt I put together a quick example: click on the calculated item of "master" automatically switch to the same calculated item in the detail.
0
