Cloud for Analytics and Geo Locations - Part 1

[IngoH]

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.