Skip to Content
0
Former Member
Feb 02, 2006 at 05:29 PM

Transfer of nested XML data to BW

40 Views

Hi there Experts

I am trying to transfer XML data to BW. I have done the worked example in the “How to … send XML Data to BW” document and it’s all working fine.

The problem with the example is that the data is in a “flat” format without any nested loops. So for one Vendor 4711 and two materials “gizmo” and “widgets” the data structure essentially looks like this:

<DATA>

<item>

<VENDOR>4711</VENDOR>

<MATERIAL>gizmo</MATERIAL>

</item>

<item>

<VENDOR>4711</VENDOR>

<MATERIAL>widget</MATERIAL>

</item>

<DATA>

Now, since we have a fair bit of data, rather than creating one new line (item) for each combination of VENDOR and MATERIAL we want to set up a nested structure in XML that can be read in BW, something along the lines of

<DATA>

<item>

<VENDOR>4711</VENDOR>

<MATERIAL>gizmo</MATERIAL>

<MATERIAL>widget</MATERIAL>

</item>

<DATA>

Unfortunately, all attempts have failed so far to create such a structure and admittedly I know very little about XML to begin with. Any ideas?

Thanks and greetings from Hamburg!

Christian