Skip to Content
0
Former Member
Oct 26, 2012 at 10:30 AM

How to create If- then- else statement in Bex query

553 Views

Hi All,

I have a requirement to replace the value of the Characteristic info object with another value of the same Characteristic info object in the Bex query, To do this I have created structure that contain Characteristic info object, then created the formula by using Boolean functions in the bex but I did not give the desired result. Please go through the example mentioned below and suggest me how to achieve this.

Example: There is a Characteristic info object called 0comapny_code which contains the values like 11, 22,AA, 33,44,55,…so on.

0comapny_code

11

22

AA

33

44

55

In the above example by mistake user entered ‘AA’ instead of ‘11’ in the source system, so then same information has flown from source system to infocube (tried to fix this in cube level but did not work bcz this is an historical fix). so now I want to replace ‘AA’ with ‘11’ in the bex query level. Please suggest me to achieve this.

Thanks in Advance

Braj