In the second video of the 17 part Extending SAP HANA Live for an Insurance Loss Triangle Business Use Case the SAP HANA Academy’s Tahir Hussain Babar, aka Bob, overviews the project’s technical architecture and demonstrates the final loss triangle application.
(0:13 – 2:50) Demo of Final Application and Definition of Insurance Loss Triangle
The Insurance loss triangle application is built with SAPUI5. The left side of the application contains a map that allows the user to draw any shape on the map and then filter the results for the enclosed area using SAP HANA’s geospatial capabilities. The loss triangle results generated by SAP HANA Live will be displayed to the right of the map.
A loss triangle is a table showing total losses for a certain period at various regular valuation dates. The loss triangle shows the changes in amounts as claims mature. Every consecutive period will have one less entry than the previous older period thus leading to a triangular shape of the table’s data. This application can also show paid losses or total incurred losses. The image below shows the total claim payment amount and the total premiums before tax amount.
The green zeros on the right side can be filled with projected amounts once the predict button is toggled on. The loss triangle is extracted from the SAP ECC table using SAP HANA Live. The data in turn is then sent to R which uses a chain ladder algorithm to predict the projected green amounts.
Filters have been built in the application that allow the user to append extra columns such as a specific Lines of Business. The application uses XSJS and OData. OData allows data to be extracted from SAP HANA by using HTTP.
(2:50 – 7:10) Overview of Architecture
A SAP HANA box running on Linux is central to the system. Located on the box are a series of SAP ECC tables which contain data. This course assumes that your SAP ERP system is loading data to your ECC tables.
The course will first show you how to install the various SAP HANA Live packages. Available at no cost, SAP HANA Live is a series of calculation views that sit atop the SAP ECC system. They contain all of the business logic so they are considered a semantic layer and virtual data model.
Then SAP HANA Live will be modified to fit the business needs for this scenario by adding extra columns and content from various views and tables within the SAP ECC system.
SAP Geospatial will be used to create a point column from Latitude and Longitude data from a series of address within the SAP ECC system. Then will enable a SAP HANA view to be created that combines SAP ECC data with SAP Geospatial tables.
Throughout the course a lot of development will be done on a Windows box using SAP HANA Studio. After the data has been extracted from the SAP HANA Live loss triangle it will be sent to a R server to fill in the zero value rows. The SAP HANA server will be configured to connect to R and certain procedures will be executed to bring back the data.
The browser based SAP Web IDE will be used for development to showcase how simple it is to use OData to extract data from SAP HANA. XSJS and SAPUI5 will be used to build the application’s UI. The HTML viewer and controller will be used to enable data from Google Maps to be used.
Check out the entire 17 video playlist for the SAP HANA Academy’s Business Use Case Analytic Solution – Extending SAP HANA Live for an Insurance Loss Triangle here.
SAP HANA Academy over 800 free tutorial videos on using SAP HANA.