Create a Geo-Coordinates Column in a Graphical View

Create a geo-coordinates column to combine latitude and longitude values and output coordinate data that can be used in an SAP Analytics Cloud geo map.

Context

When using the geo-coordinates column in an SAP Analytics Cloud geo map, the following types of layers are supported: For more information see Creating a Geo Map in SAP Analytics Cloud.

Procedure

  1. Create your graphical view and set its semantic usage to Dimension.
  2. Select an appropriate node in the diagram to display its context tools and click Calculated Columns.

    A calculated column node is created, its symbol is selected, and its properties are displayed in the side panel.
  3. Click (Add New Calculated Column) > (Geo-Coordinates Column) to create a new geo-coordinates column.
    The new column properties are displayed in the side panel. The column is named Location by default.
  4. Complete the column's properties:

    Property

    Description

    Business Name

    Enter a descriptive name to help users identify the object. This name can be changed at any time.

    Technical Name

    Displays the name used in scripts and code, synchronized by default with the Business Name.

    To override the default technical name, enter a new one in the field. Technical names can contain only alphanumeric characters and underscores.

    Spatial Reference Identifier

    Every spatial reference system has an identifier called a Spatial Reference Identifier (or SRID). By default, it is set to 4326 but can be changed to 0 or 3857. For more information, see Spatial Reference Identifier on SAP HANA.

    Latitude and Longitude

    These columns must have string or double as data types.

  5. Click (Save)Start of the navigation path Next navigation step SaveEnd of the navigation path to save your entity or click (Deploy) to save and deploy it immediately.
    For more information, see Saving and Deploying Objects.

Results

To use the geo-coordinates column in SAP Analytics Cloud you should now: