Transpose columns to rows in SAP BW

[former_member512864]

Hello,

I want to transpose colums from my datasource to rows in my data target like the scenario below

Source System ( Datasource) :

Destination (DSO) :

How can I get this result ?

Thanks in advance for your help.

[Private_Member_484518 · Accepted solution]

Hi Ahmed,

1. You can write Start Routine or End Routine in Transformation.

2. We can use the Rule Groups functionality to achieve the same.

Please follow the below thread for step by step procedure.

http://dailybusinessobjectsupport.blogspot.com/2011/09/transposing-fields-in-sap-bw.html?m=1

Regards,

Geetha.

LinkedIn Profile: https://www.linkedin.com/in/geetha-madhuri-971268184/

[shanthi_bhaskar]

I had previously but I dont have code now, You need to do this with by using the ABAP Event like AT FIRST, AT LAST etc.. I had done using the Expert routine.

[former_member512864]

Thanks for your reply Shanthi , I succeed to do it using an AMDP Script.

[former_member231709]

You can use for this "Rule Groups" in transformation. For example: https://archive.sap.com/documents/docs/DOC-11537

[former_member512864]

Thanks for your reply Eugeniy, do you think I can use "Rule Groups" if I have hundred of columns to transpose to rows?

best Regards,

Ahmed

[former_member231709]

You may use for this coding in expert routine. It might be easier.

[former_member512864]

Do you have some examples of "expert routine" I can use to transpose colums to rows ?