Skip to Content
0
Jun 21, 2020 at 11:34 AM

BEx Query Show a characteristics based on value of other characteristics

87 Views

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