Skip to Content
Author's profile photo Former Member

Distance Between Two Points on a Map

Some of the fundamental features of maps include locating points and plotting regions. This blog focuses on calculating the distance between two different points on a Geo Map, thus leveraging the use of maps. Finding distance between two points on a map could add a lot of value to business especially when it comes to tasks like sales territory optimization. Now, let us take an example showing sales offices for various zip codes in the state of Texas.To create points that represent data on the map, the latitude and longitude values have to be measures and the point to be plotted is kept as dimension. Below is the sample of the data set that I have used to create this application. In this data set, I have the zip codes of Texas State in USA and its corresponding latitude, longitude coordinates.

In the additional properties tab, enter a name for the layer and choose the following appropriately.
1. Type – Marker
2. Data Source
3. Latitude
4. Longitude
5. Color for Marker

By using the mathematical functions in SAP Design studio, the distance is calculated between the two locations. In our example, the distance is calculated between sales offices in two zip codes.
The map below shows the sales offices plotted in various zip codes. When we click on a particular sales office in a zip code, it gets displayed as shown below.

Now, select the end point i.e. the second sales office. When selected, the distance between these two sales offices are shown.

Please note that this calculated distance is the diagonal distance between two sales offices and not the distance on road. This type of analysis can also be used for goods distribution from a warehouse or between warehouses.

For more information, reach out to Visual BI 

Assigned Tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Mustafa Bensan
      Mustafa Bensan

      Hi Suriya,

      In this blog you have described the problem without providing a solution.  As a suggestion for improvement, your post would be more educational to readers if you also:

      • included the script code with "mathematical functions" you refer to for calculating the distances
      • described how the calculation of such distances add value for "sales territory optimization"

      Regards,

      Mustafa.

      Author's profile photo Former Member
      Former Member

      Hi Suriya,

      thanks for this blog. I find it is an interesting and informative blog. Nevertheless I find the points from Mustafa correctly, which is missing here. For me is the followed questions important:

      • can you calculate the distance between 2 locations over street
      • can be represented between locations with lines instead of points
      • and can be displayed the line strength after the value stream

      So I can define a location for a possible work.
      Thanks for your answer.

      Regards,

      Mehmet.