Add Geomap Support to Datasets

Before you perform geospatial analysis in stories, you must first enrich your dataset with coordinate or area data.

Prerequisites

You must use acquired data from supported sources such as SAP BW or a file (.xlsx or CSV). The data must contain a location ID column with unique data, as well as either latitude and longitude columns, or country (required if your regions and subregions are in different countries), region, and subregion columns.

Context

These steps describe how to enrich coordinate or area data.

Procedure

  1. Open your dataset.
  2. Select (Geo Enrichment) in the toolbar, and then choose either of the following options:
    • By Coordinates if you want to use latitude and longitude data to enrich a dimension or create a location dimension.
    • By Area Name if you want to enrich a dimension based on country, region, and subregion data. The country data can be imported as ISO3 and ISO2 codes, or the country names in English.
  3. Provide the following information:
    • By Coordinates:
      In the Geo Enrich by Coordinates pane choose:
      • The Enrich Dimension tab if you want to enrich an existing dimension with geographical data. If you select this option, you need to provide the following information:
        • Dimension ID: use the list of available dimensions to select the dimension you want to enrich.
        • Specify the corresponding dimensions for Latitude and Longitude.
      • The Create New Dimension tab if you want to create a new location dimension with geographical data. If you select this option, you need to provide the following information:
        • Dimension Name: This is the name of your new location dimension. You will need to specify this name when creating geo maps in your stories.
        • Specify the corresponding dimensions for Latitude and Longitude for the new location dimension.

          Note
          When specifying coordinates, SAP Analytics Cloud only supports the decimal degrees format (with the degree symbol omitted). For example: A latitude of 38.8897 and a longitude of -77.0089.
    • By Area Name

      Choose how you want to specify country for your Geo Hierarchy:

      • Select Column a Column in your Dataset: if you want to select the column containing the country data.
      • Specify from a list of countries: if you want to select a specific country from a dropdown list.
        Note
        If you select a country from the list, after the data is geo-enriched, it will be limited to areas within the selected country. To view a list of supported area names, use the provided Supported Locations link.
      • Optionally associate Region and Sub-Region with corresponding columns.
  4. Select OK.
    Your target column is now be geo-enriched or a new column is created for the location dimension. Any data quality issues are displayed in the Details panel.

Results

When working with stories, the location dimension will be available to add to geo maps.
Note
In your geo maps, use the choropleth/drill layer to navigate through location dimensions enriched By Area Name.