Changing the Characteristic Values on the Query

[Former Member]

Hello Masters of the BW Domain

Is there a way to display the values of a characteristic in a report based on a condition? I have a characteristic called Rebates with only 2 valid values (Y and N). Instead of showing it as Y and N, I want them displayed as "With Rebate" for Y and "No Rebate" for N. Is it possible to do this without changing the underlying data in the cube and doing the translation at the query level? Would it require a user exit to accomplish this? All the user exits that I've run into only dealt with dates and not with transforming text values.

[Former Member · Accepted solution]

You can add text to the Infoobject and display it on the query.

Regards

[Former Member]

As Paolo suggested you can add text for the info object. Else if you are using BW Web Reports you can use the Table API(similar to user exit) to do the conversion.

case i_iobjm .
  when 'rebates'.
 
    if i_value = 'y'

      c_cell_content = 'With rebate'.

    elseif i_value = 'N'

      c_cell_content = 'With rebate'.

    endif.


endcase

.

*Please check for the syntax.

If you are using BEx, VB macros will be an option.

The best approach will be to store text for the info object.

Thanks.