As I haven’t configured my Cloud for Analytics System with SAP BW or SAP HANA yet, I continue my sharing here (and my Wishlist) based on data from Google Sheets.
So I created a quick Google Sheet with a set of Geo Locations…
… and went then on to create the model based on the Google Sheet like we did in a previous blog already.
After I imported the data into the model I quickly changed the model, so that the column Revenue was identified as Key Figure and the columns for the Longitude and Latitude were identified as generic ID dimensions. After that I was looking for an option to setup my location in the data model so that I would then be able to link the location later on to a map in the visualization.
I found the item in the context menu of the Column City…. (see below)….
So I went ahead and chose the menu item Create Location and assigned the Longitude and Latitude dimensions.
and after clicking “Create” I received a small message stating, that all values were correct.
But that message brought up a good point: What if I had made a mistake ? So I wanted to see how I can change the definition of my location….
… and I think I have to add this item to my wishlist as it seems that setting up a location in the model is so far a “one-time” definition.
In the model I then received an additional column that combines the longitude and latitude values and it was configured as “ST-Point” on the attribute type.
So I received the location in my model and should now be able to use that as part of my next visualization with maps.
One additional note – for a Dimension with a Location attached to it, the rule seems to be that the dimension values have to be unique – even when the longitude and latitude values are different.