Cloud for Analytics and Geo Locations – Part 2
In the first part we used a Google Sheet with Longitude and Latitude values and associated the values with our dimension City.
In this part we will now use the information and take a look at the Geo Visualization options in Cloud for Analytics.
So I started by creating a new story and adding a new empty canvas.
I then point the map to my previously created model…
and we can now start configuring the map. On the Layer part we have the choice between a Bubble Layer, Choropleth, Heat Layer, Point of Interest, Feature Layer.
I assume that most of you are familiar with the Bubble Layer, Heat Layer, and the Choropleth layer.
The Point of Interest Layer is something that you model separate and you can then display it (without a measure associated to it) on the map. An example would be something like (remember I am from Canada) all locations from Tim Hortons.
A feature layer allows you to use a web service URL in combination with ESRI for that particular layer.
In our example lets start with the Bubble Layer.
for the Location Dimension I can now choosing my cities – so far you do not have the option to assign directly the Longitude and Latitude dimensions.
I then used the measure Revenue for the color and did select a color palette and chose 5 ranges.
and the next step somehow reminded me of the first time maps were possible for Design Studio.
The map zoomed out, tried to center the map around all my data and I could not find some configuration details were I was able to configure the Zoom Level or the start location (added to the Wishlist).
The Basemap option provided me with several options to choose from….
… and the Map Filters is something we will explore next time. Basically the Map Filter allows you to find data points in a certain range / distance.
My Wishlist:
- I would hope that I will be able in the future to use longitude and latitude values without having to model a location first
- I think it also would make a lot of sense to be able to add a measure to a Point of Interest Layer
- and it would make sense to be able to edit a previously defined location dimension
Hey,
Great Piece. Thanks for Sharing.
Somehow Screens are now changed in SAP Analytics , had to map .
Thanks Again !
Hi,
I am trying to perform geographic spatial data in SAP HANA to view it on a map in BO Cloud, but I have problems seeing the coordinates, I followed the instructions in this blog:
https://blogs.sap.com/2014/08/18/sap-hana-academy-geo-spatial-in-sap-hana-creating-spatial-type-data-from-an-existing-table/
I did:
When I generate the view, it is displayed as follows:I think the drawback is in the data of latitude and longitude because it appears to me with fewer decimals:
When I look at the Google map latitude and longitude with more numbers is graphed correctly but when I look for the coordinates that were generated by the view, this is not recognized.
What can I do to be able to visualize the map with the coordinates in BO Cloud?
Thank for your Help!!
Try changing the data type of your coordinates to double instead of decimal.