OBIEE - grouping columns

Question

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.

Gianni Ceresa · Answer

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.

3427784 · Answer

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!

Venkata Yaswanth Ramisetty · Answer

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