on 02-17-2011 3:59 PM
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?
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
76 | |
8 | |
8 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.