How To Concatenate Characteristics in BEx Query Designer?

[Former Member]

I want to concatenate three columns together in QueryDesigner. I am interested in doing this because I plan to use a SUMIF statement abainst the single column rather than doing a SUMPRODUCT against three columns. Is there an easy way to do this in Query Designer?

[sri_pamarthi]

Dear Vinay,

Please follow below steps.

1. Add Virtual Characteristic in the Provider.

2. Create a BADI through below mentioned ref

BADi RSROA_OLAP_BADI for creating virtual characteristics with your logic :

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

Thanks,

Ram Pamarthi.

[former_member285763]

sri.pamarthi Is there any way to populate calculated Chars directly at Bex Designer without touching backend info providers ?