Hardcoded Alphabet in Bex Query

[sandeepsinha327]

Hi All,

I have a key figure (say KF1) which is a calculation and hold some numeric value.

Now my requirement is to display some hardcoded values with reference of the above field.

Detailed Explanation

I need to write an IF statement which should go as shown below:

If KF1 <= 1 then A, IF KF1>1 and <=3 then B, IF KF1 >3 and <=6 Then C, ELSE Z.

How can I achieve the above in Query designer as it does not allows to enter a alphabet in the formulas.

[former_member231709]

You can use a Virtual Characteristics for this requirement:

https://wiki.scn.sap.com/wiki/display/BI/Virtual+Key+Figures+and+Characteristics

Also you can implement situable code in transformation (end/start routine).

[anshu_lilhori]

Hi,

its not possible to use char in BEx.

Either you can do this at modeling level or if you have flexibility to use other front end tools then WebI.

Hope this helps.

Regards,

Anshu Lilhori