Flatten Nested (Hierarchical) XML file

[manish_umarwadia2]

Hello,

We are looking to load an XML file into BI. However the XML file is Nested (Hierarchical). Would XI be able to flatten the XML file? We would like to push the data into BI using ABAP proxy and BI would not be able to deal with a nested XML file directly pushed using SOAP RFC or Web services.

Thanks.

[Former Member]

HI Manish

This can be handled in mapping. Map records based on occurance and item level details to pass exact date to other side and you are done !!!!

Thanks

Gauarv Bhargava

[Former Member]

HI Manish

Heirarcy will not create any problem posting XML data to BI. But flattered means are you going to post flat file or making changes to XML structure before posting??

Thanks

Gaurav

[manish_umarwadia2]

In the nested structure, there are repeating sections where the header is not repeated. Flatten would imply each data record contains all fields, i.e. the header/parent gets repeated at the child level.

H-

|_A1_

|_B1 -

---

> HA1B1

|_B2 -

---

> HA1B2

|_A2_ HA2B3

|_B3

[Former Member]

yeah,you can do handle this in mapping

Thanx

Aamir

[Former Member]

>>flatten the XML file

could you please tell what you mean by <i>flatten the XML file</i>.?

Thanx

Aamir