Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
Showing results for 
Search instead for 
Did you mean: 
Active Contributor

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.


Labels in this area