Data Connection with XML Data ---- Problem with XML Elements of Row and Column

[Former Member]

I am using external XML file for my dashboard.

Problem is that it only reads XML file with <row> and <column> elements.

<row>

  <column/>

  <column/>

  <column/>

</row>

I want to use specific Elements Names to replace <column>.

Because my XML file comes from Excel File.

For example, I want to use Elements names like below:

<row>
  <Sales></Sales>
  <Target></Target>
  <Achievement></Achievement>
 </row>

Could anyone please give me guidance on this matter...

Thanking you in advance...

[nilesh_pawar6 · Accepted solution]

Hello Hayden,

Kindly refer the below link for XML data connectivity in Dashboard.

Auto update Xcelsuis data and dashboard from XML Ep1 - YouTube

Regards,

Nilesh Pawar

[Former Member · Accepted solution]

Thank you for sharing this video.

I ended up using VBA but this is helpful. Thanks.

[nilesh_pawar6 · Accepted solution]

Thank You Hyden Points appriciated...!

[Former Member]

I found this method to use VBA to create the XML file.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/80473ce4-27f3-2e10-b185-a0d6eef75...