Continuing from SAP BusinessObjects Cloud Location Analytics – Bubble layer and Basemap I would like to show you how you can add POI data and quickly visualize from within SAP BusinessObjects Cloud. After that, I will introduce you examples of spatial analysis you can perform between your modeled analytic data and POI data. These spatial analysis directly uses SAP HANA Spatial engine.
SAP BusinessObjects Cloud allows you to bring location data of your interest from
- Esri shapefiles
- Microsoft Excel or CSV files
- Your existing modeled data
Unlike analytic data, POI data does not require you to have measures. Using shapefiles you can also display data other than points, such as polygons, multi-polygons, lines and many more. You need to have the Modeler or equivalent custom rights which allow you to import data into the system. If you only have Viewer rights, chances are you will not be able to import the data. You will need to contact the administrator that can give you the rights to import data.
POI from shapfiles
In the following set of recordings, you will see examples of importing POI from shapefiles and adding POI layers to the map in your story. For point data, you can also customize markers.
This is another example from Mexico showing lines and points from the shapefiles.
In the current release, we support 3 Spatial Reference IDs supported in SAP HANA 11. Latest versions of SAP HANA supports much more and we will be looking to updating the support in the future.
POI from Excel/CSV data
There are two ways to import POI from Excel/CSV data.
This is the fun way – drag and drop the file on your map. Boom!
Data is imported to the system and POI layer is added automatically. As you can imagine, for this workflow, we support specific set of column names. Following column names are recognized for this drag and drop feature and they are not case-sensitive:
- Latitude: first column with the string that contains ‘latitude’ or ‘lat’
- Longitude: first column with the string that contains ‘longitude’ or ‘long’
- Tooltip: optional. first column with the string that contains ‘tooltip’, ‘name’, or ‘id’
If you do not want change your column names or orders, we recommend you to add POI through the Modeler > Points of Interest, Quick snippet below:
For both ways of adding POI from MS Excel/CSV, you need the rights to import data as mentioned above.
POI from Modeled Data
If you already have Location enabled analytic or planning models, you can also convert it and use it for the POI layer. Select your model and Location Dimension of the model.
Spatial Analysis: Distance Filter and Distance Slider Control
SAP BusinessObjects Cloud uses SAP HANA Spatial to perform various spatial analysis and calculations. Today you can perform filter operations such as “Give me all the store locations from transaction data that are within 10 KM from my POI”. We call this Distance Filter. In Distance Filter, you can change Within operation to Not Within and you can change the unit of the distance. You can add multiple distance filters. You can also add a Distance Slider control to your map so that you can change the distance in view time and see how your data changes as you move the slider.
Spatial Analysis: Intersection
You can also perform Intersection filtering. In the following example, I have Washington Parks shapefile as a POI layer and coffee shop locations as my analytic data for Bubble layer. I am filtering all the coffee shops that intersects with the parks.
The resulting data looks like this:
Compare this results to when I inverse the filter to Not Intersecting.
At a first glance, it may look like some of the coffee locations still intersect with the parks. When you zoom in really close, you will see that the points don’t quite touch the borders of the parks.
This is where I will leave you today. I have covered 2 of 6 layers we have so far. We have a long way to go 🙂
I hope you get to have some fun!
Credits: My super developers in The Dire Wolves and Honey Badgers!