Skip to Content
Author's profile photo Ingo Hilgefort

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.


Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hi Ingo Hilgefort,

      Thanks for sharing this helpful article.

      I am using SAP HANA Analytic View as a source ( i.e. through Live Data Connection from HCP) and when I go to the modeler in BO cloud, I do not get to see any of my dimensions but just measures ( i.e. Accounts). Can you please advise how can I then create Location dimension here to map Latitude and Longitude?

      Many thanks,


      Author's profile photo Former Member
      Former Member

      Hi Ingo Hilgefort,

      I would also like to know the answer to the exact same question above.

      Thanks in advance,


      Author's profile photo Ingo Hilgefort
      Ingo Hilgefort
      Blog Post Author

      Hello Megha,

      when you connect to the model, do you see the actual Dimensions and measures and what dimension type is being recognized ?

      This is about the geo Location, in case you already facing the issue with importing the model / connecting to the model and dimensions not being recognized then I would suggest you post your question into the forum.



      Author's profile photo Former Member
      Former Member

      Hi Ingo,

      thank your for your fast answer.

      I have found the solution here:

      See the attachment Manually Enriching a HANA View.pdf' in the following release note for more information:

      Author's profile photo Giovanni Leggio
      Giovanni Leggio
      Author's profile photo Former Member
      Former Member

      This information has now been moved to the "Creating_Geo_model_from_LiveHana.pdf" attachment in the following SAP Note.

      Author's profile photo Kiran Shenvi
      Kiran Shenvi


      This document is specific to HANA live connection.

      Do you have any document to share or workaround with BW as Live connection?



      Author's profile photo Former Member
      Former Member

      Thanks Ingo! The query has been handled on forum as directed by John.