GEO Enrichment in SAC(SAP Analytics Cloud) with coordinates



 Let's upload a flat-file which have latitude and longitude coordinates. Here we are using a sample data of flight data.


Create--> Model





We have latitude and longitude coordinates of both the origin and destination of the flights.



Now let's create Geo enriched calculated columns for origin and destination.



Origin coordinates


Destination coordinates


Now we have 2 geo enriched columns origin and destination


now create data model


Our data model is ready now. let's see how we can use this data model in a story. 



Create--> story


Choose a template for your story


Click on the + button to add layers.





choose the type of layer we want to use. As we are having an origin and destination coordinates, we can choose the flow layer


Connect to our Data Source(Data model which we created earlier)


Mention the Origin and Destination 




Now the path of flights looks cluttered. so let's use few filters to make it simple.






we have selected only 3 Destination states



For adding more layers, click on the Add layer button





Now pointing at the bubble, we can see the details of the particular flight.




Comments

  1. Thanks for this knowledgeable post, I have a question here;
    I want to use SAC Geo Map with BW 7.4/7.5, where I am having 0GEOFEATID having longitude and latitude attributes.
    When I trying to load data, through RSD_GEO_SYNC_ATTR, its giving error.
    “Infoobject 0GEOFEATID needs to be a Navigational Attribute of Characteristic 0GEOFEATID”
    “View _SYS_BIC.FPA_SPATIAL_DATA.choropleth/CHOROPLETH not found on DB”
    Can you please suggest and help to solve this error.
    Thanks

    ReplyDelete
  2. Thanks for this knowledgeable post, I have a question here;
    I want to use SAC Geo Map with BW 7.4/7.5, where I am having 0GEOFEATID having longitude and latitude attributes.
    When I trying to load data, through RSD_GEO_SYNC_ATTR, its giving error.
    “Infoobject 0GEOFEATID needs to be a Navigational Attribute of Characteristic 0GEOFEATID”
    “View _SYS_BIC.FPA_SPATIAL_DATA.choropleth/CHOROPLETH not found on DB”
    Can you please suggest and help to solve this error.
    Thanks

    ReplyDelete

Post a Comment