SAP Guides, SAP MM Certifications, SAP MM Tutorials and Materials, SAP HANA

SAP HANA on a whim: A Bing map in MS Excel from an anonymous OData service

This time, I wanted to add a Map and answer to the question “What If I cannot install the MDX plugin in Excel?”.

SAP Guides, SAP MM Certifications, SAP MM Tutorials and Materials, SAP HANA

Our integration is done with an anonymous OData service.

In MS Excel, it’s as simple as going to the Data ribbon, then From other sources and then choosing From OData feed:

SAP Guides, SAP MM Certifications, SAP MM Tutorials and Materials, SAP HANA

Note: If you have the Power Query add-in, the wizard from the “New Query” menu is a bit more friendly and allows for basic authentication. The steps are pretty much the same.

Paste the URL to your .xsodata service (you can leave the sign-in options as they are, since your service is anonymous):

SAP Guides, SAP MM Certifications, SAP MM Tutorials and Materials, SAP HANA

And choose from the tables you want:

SAP Guides, SAP MM Certifications, SAP MM Tutorials and Materials, SAP HANA

Fill in the name and description of your feed in the next step and let the data in:

SAP Guides, SAP MM Certifications, SAP MM Tutorials and Materials, SAP HANA

Now I have a table with cities, that can be mapped into the Bing Maps add-in from MS Excel:

SAP Guides, SAP MM Certifications, SAP MM Tutorials and Materials, SAP HANA

Select the data from your table and click on the “pin” icon on the top right corner of the map add-in for it to include it as a source… Ta-da!

SAP Guides, SAP MM Certifications, SAP MM Tutorials and Materials, SAP HANA

Leave a Reply

Your email address will not be published. Required fields are marked *