[SAP HANA Academy] Live 4 ERP Agility: Using the Live 4 Map

In this tutorial video the SAP HANA Academy’s Jamie Wiseman demonstrates how to use the Live4 map application. The map application is one part of the ERP Agile Solution demo application. The SAP HANA Academy’s ERP Agile Solution Live4 demo details how you can securely marry data from your ERP system to externally sourced data via the SAP HANA Cloud Platform.

The SAP HANA Academy will build, for free, an ad hoc ERP Agile Solution for any and all SAP ERP and Business Suite customers. Please contact us at hanaacademy@sap.com to inquire about an ad hoc ERP Agile Solution. Watch Jamie’s tutorial video below.

(0:20 – 2:25) Overview of the Live4 Map Tile

In the main ERP Agile Inventory demo SAP Fiori application click on the Map title. The map is a SAP HANA XS application which was created using SAPUI5 and utilities the HERE Maps’ API. The popped up text box that reads 48,244,638 at the bottom of the application is the total population (derived from census data) of the map’s current boundaries. Panning or zooming the map will run a web service against one of our SAP HANA database tables to return a new total population for that area.

In fact every time the map’s boundaries are changed a trio of web services are run against the SAP HANA system. The second web service returns all of the current store information from the SAP ERP system and also the current air quality and weather data from the Hadoop data lake. Depending on the area, this data can be culled from up to three separate weather stations. SAP HANA’s geospatial capabilities are used to identify the weather stations closest to each store.

On the map a blue circular marker represents each store location. Clicking on a marker will display the store name, the reading from its closest AQI station, and the local area’s humidity and temperature. The pop over pictured below shows no inventory alerts for the Drugs R Us Bishop location. Clicking on the Alerts button on the bottom banner will detail where alerts are currently occurring. Right now in Jamie’s example no store has an alert.

(2:25 – 3:55) Internet of Things Simulator

Back in the Live4 home SAP Fiori application screen click on the Simulator IoT title. In this screen you can manually change the AQI, temperature, and humidity values for each individual store. In this tutorial example Jamie ramps up the AQI, temperature and humidity for the store in Bishop to force some predicted inventory issues.

Back in the map title if we just pan the map a little bit we will return new information from our SAP HANA system. Now any store with an inventory alert will be marked by a slightly larger red circle. If you click on a red alert marker you will see all of the stores that can transfer the needed inventory of certain products with high demand and low supply to that location. We are using SAP HANA geospatial to find out the nearest transfer store with enough excess product to sate the alerted store’s demand without resulting in a shortage of their own.

Now the Alters option lists a table with the full set of products that have inventory alerts along with the transfer store information. This information represents the third web service that is being run against the SAP HANA database.

(3:55 – 4:40) The Map Application’s Charts and About Options

In addition to the population total mentioned earlier we can also view other demographic information in the map application by clicking on the Charts option in the bottom banner. The charts show demographic information about the map’s current boundaries including gender, age, education and commute.

If you desire further details about the maps application click on the About option in the bottom banner. This will pop up a key for the different symbols that can be displayed on the map and also links to a ERP Agile Solution User guide as well further information on the SAP HANA Academy.

For further tutorial videos about the ERP Agile Inventory with HCP course please view this playlist.

SAP HANA Academy – Over 1,000 free tutorial videos on SAP HANA, Analytics and the SAP HANA Cloud Platform.

Follow us on Twitter @saphanaacademy.