O'Reilly logo

Learning SAP BusinessObjects Dashboards by Taha M. Mahmoud

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using XML data

We can use XML data to populate our dashboard with data. To do this, we first need to display the Developer tab in Excel. This is because we will call the XML URL from the Excel Developer tab.

Go to the Excel options and show the Developer tab, as marked in the following screenshot:

Using XML data

Now, let's follow the steps to establish an XML connection:

  1. Open a new dashboard file, or you can open XML Maps.XL from the side examples folder under the example code.
  2. Navigate to the Excel model and click on the Developer ribbon.
  3. Click on Source and then on XML Maps….
  4. Click on Add… and enter the following URL in the open field: https://maps.googleapis.com/maps/api/timezone/xml?location=39.6034810,-119.6822510&timestamp=1331161200 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required