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