Skip to Content

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…

 

C4A_Blog_Geo_001.jpg

 

… and went then on to create the model based on the Google Sheet like we did in a previous blog already.

 

C4A_Blog_Geo_002.jpg

 

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)….

 

C4A_Blog_Geo_003.jpg

 

So I went ahead and chose the menu item Create Location and assigned the Longitude and Latitude dimensions.

 

C4A_Blog_Geo_004.jpg

 

and after clicking “Create” I received a small message stating, that all values were correct.

 

C4A_Blog_Geo_005.jpg

 

 

 

 

 

 

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.

 

C4A_Blog_Geo_006.jpg

 

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.

 

8 Comments
You must be Logged on to comment or reply to a post.