Hello Gurus ,
I have 2 characteristics CHAR_A and CHAR_B ( both have text data ) . In output I want to show CHAR_B data based on specific value of CHAR_A .
For example , CHAR_A has values A,V,R,S etc and CHAR_B is a like a supplier number .
Now what I want in the query output is
If CHAR_A = 'R' then show CHAR_B ELSE show NULL ( #)
I tried different options including creating structures and calculation but it does not work .
So my questions are
1) What are different options available to achieve this functionalities? How we can make it ?
2) Is there any way we can do something in BEx query itself as changing underlying Cube structure will be difficult.?
Thanks
Amit