Help Needed to Integrate Geographical Map in SAP Story

[gabriela_jacomino]

Hi community,

I am working on a story in SAP that consumes data from a model based on a graphical view in Datasphere. I would like to incorporate a geographical map to better visualize the information, but I can’t find how to create the location dimension.

Could someone guide me on how to integrate a geographical map into my story? I appreciate any advice or resources you can share.

Thank you very much in advance!

[bheemeshRao]

Hi @gabriela_jacomino 

1. your dataset should have latitude and longitude fields

2. Create a graphical view on top of the table having the latitude and longitude, make the view as dimension

3. In the calculated column section add Geo-coordinates column (this option is available only if the view is selected as "Dimension"

4. The latitude and longitude columns are automatically selected else select them from the drop drown

5. Activate the view

6. Associate this dimension view with your facts view

7. Build analytic model on top of the facts view, enable expose for consumption

8. Go to SAC, select the Geo-Map Widget

9. Click on Add Layer, under Location dimension section select the Geo-coordinates field that was created in the view

10. Add measures, you will be able to see the geo-maps

[ShaikAzmathulla]

Hi ,

To incorporate a geographical map and create a location dimension, follow these steps:

1. Use the SAP Analytics Cloud Model API to retrieve your data model:

   • Endpoint: GET /sap/analytics/cloud/api/v1/models
   • Identify dimensions for location data.

2. Create a Calculated Dimension for geographical coordinates if not present:

   • Use SQL-like syntax to combine latitude and longitude. For example:
     sql

     Copy code

     CASE WHEN Latitude IS NOT NULL AND Longitude IS NOT NULL THEN CONCAT('POINT(', Longitude, ' ', Latitude, ')') ELSE NULL END AS Geolocation

3. Upload GeoJSON Data (if using custom regions) to enrich the model.

4. Visualize in SAP Analytics Cloud:

   • Add a map visualization and assign the location dimension.