Skip to Content
Technical Articles
Author's profile photo Simon Lyng

How to geoenrich your dataset based on country

When you have a dataset and wishes to show a keyfigure on a map, there are two different ways of having your data represented on a map:

  • By entering Latitude and Longitude
  • By using Aera

But in a normal dataset, you usually do not have Latitude and Longitude, and you can then use Country as an Aera.

In SAP Analytics Cloud, there is a link to an updated file with all the supported regions/countries

But in order to enable the geoenriching, you will have to create a model, and do your data wrangling – make sure that only supported countries are in the list of countries, and select the button Geoenrich:

When selecting Geoenrich by Area, you can then select the existing Dimension you wish to use as geoeriching field, and create a new field – Then you create a new name for this field, and you have to decide to use Country and/or region

 

Once the model then is build, you can use the new Dimension in the GeoMaps as Geographical locations – In this model we are showing the Poupulation on a map.

 

Conclusion: You can use GeoMaps even though you don’t have the Latitude and Logitude of contry or regions – By using the Geoenrich by Aera functionality in SAP Analytics Cloud

Assigned Tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Adam Nekola
      Adam Nekola

      Hello Simon Lyng,

      thank you for sharing this with us! Does this feature works with live models (f.e. BW 7.50)?

      Thank you!
      Adam

      Author's profile photo Simon Lyng
      Simon Lyng
      Blog Post Author

      Hi

       

      According to this Wiki:

      https://wiki.scn.sap.com/wiki/display/BOC/SAP+Analytics+Cloud+Support+Matrix#SAPAnalyticsCloudSupportMatrix-FeaturesparticulartoCharts

      Geo Enrichment is only available using Longitude and Latitude, when using SAP BW

       

      Regards

      Simon Lyng

      Author's profile photo Adam Nekola
      Adam Nekola

      I see. Thank you very much for the info!
      Adam