Create a formula in a query for a text characteristic

[Angela12]

Hello, I would like to create a formula in a query for a text characteristic (IF(0COUNTRY = 'Brasil', 'BR', 'Null'). How can I do that in SAP BW?

[Anand71]

Are you using BW4HANA?

[Ivan_Camac]

If you are using standard objects in SAP BW, then I am surprised you would need to do this. 0COUNTRY is an SAP delivered object configured as CHAR(3). The ID in this case would be 'BR' as per your example and the text as 'Brazil'. The Keys and Texts are loaded from standard datasource 0COUNTRY_TEXT. Perhaps the requirement is the 'Null' bit if the Country is not Brazil?

[RaymondGiuseppi]

Look for Calculated Attributes in SAP HANA Modeling Guide for SAP HANA Studio