Cloud for Analytics and Geo Locations – Part 1

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.