Conditions on Characteristics

[Former Member]

Hi BW Experts,

I have a Characteristic say Payment terms now the requirement is when Payment term is = 'XYZ' then assign 'ABC'. I have tried to create a replacement variable for Payment terms as numeric and now i am getting the ( formula variable ) in column but

1) I dont see any value when i run the report

2) I am not able to assign / check for a characteristic value like ABC or XYZ.

Any help / information would be helpful.

Points shall be awarded.

Thanks.

Warm Regards,

Akilesh

[Former Member · Accepted solution]

hi, do u want the assignment to happen in only one report or in all reports????

if u want it in all reports that is data target level why dont u replace it in update / transfer rules itself.

[former_member188975]

Hi Akilesh,

You cannot assign a condition on chars or check for the char values. If you need to check if the char value is ABC or XYZ, then you can try to model an attribute for this char and assign 1 when the value is ABC, 2 when the value is XYZ and so on. Then pull this attribute into the report using the formula variable replacement path, and use that to determine what the char value is.

Hope this helps...

[Former Member]

Yes, use the attribute to display the value. Replacement path as a formula variable only works if the value is numeric because formula values must be numbers since all the calculations and purely mathematic.

[Former Member]

HI,

This assignement has to be in the report because the Characteristic i am using is the Master data and the requirement is only for this report.

Thanks.

Warm Regards,

Akilesh