Some time ago, I published a blog about
connecting MS Excel to an SAP HANA calculation view using the MDX client. This time, I wanted to add a Map and answer to the question "What If I cannot install the MDX plugin in Excel?".
Our integration is done with an anonymous OData service. The steps to configure and publish an anonymous OData service are covered extensively in this blog
series about exposing predictive analytics into a Google Spreadsheet and the tutorial referenced within those series. So that piece is covered.
In MS Excel, it's as simple as going to the
Data ribbon, then
From other sources and then choosing
From OData feed:
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):
And choose from the tables you want:
Fill in the name and description of your feed in the next step and let the data in:
Now I have a table with cities, that can be mapped into the Bing Maps add-in from MS Excel:
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!
Wasn't that easy?
As always, let’s stay in touch
or on LinkedIn
Also, thanks
gregorw for tipping me into the anonymous piece.