Skip to Content

In the next blog Rob Case (rob.case@sap.com) explains how to consume an HANA Rules Framework rules’ results with SAP Lumira

 

SAP HANA Rules Framework Preparation and Rule Creation

The first part (this blog) of this tutorial describes the typical preparation required for an SAP HANA Rules Framework application regardless of how the results are to be consumed.

The second part describes steps that need to be undertaken to visualize the results in SAP Lumira.

The HANA Database and SAP HRF content that I use as a working example in the pages below are contained in the accompanying attachment “HRF Content for Lumira Example.rar” in HRF’s Jam page. This file allows you to browse individual SAP HRF resources as reference objects, but also gives you the ability to paste the whole content into an SAP HANA Studio Project Explorer tab and activate it against an SAP HRF enabled server installation.

SAP HANA Rules Framework Overview

SAP HANA Rules Framework is perfect for handling complex analytical rule constructs in real-time (online) and batch (offline) scenarios and makes the best use of the power of SAP HANA in order to achieve this. The built-in Fiori user interface that is distributed as part of SAP HRF is excellent at providing rule creation and management and allows rule results to be displayed in a textual manner. SAP HRF is all about providing the ability to allow business users to control, influence and personalize decision making in highly dynamic scenarios within the organisation in the most efficient and robust manner. Outside of SAP HRF it is the calling applications responsibility to make use of the decision results and actions that SAP HRF has returned.

Whilst the result set displayed by the SAP HRF user interface is informative, this can often be greatly enhanced by using a presentation tool to graphically represent the HRF output. One of the easiest ways of providing this type of graphical rendering is to use SAP Lumira. As a fairly novice user of SAP Lumira I am not going to delve much into how to use this tool – there are plenty of examples of this already in existence – this narrative is aimed very much more at describing the interfaces between SAP HRF result views and how to consume them in SAP Lumira.

I am going to lead you through a simple example by taking an SAP HRF rule, consuming the results of that rule in SAP Lumira, modifying the rule so that different results are obtained before refreshing SAP Lumira to present the updated results.

HANA Database Entities

Database Tables

First of all I will start with a very simple fact and dimension tables:

Fact Table SALES_QTY

SALES_QTY

id

product_id

description

sales_month

budget_qty

actual_qty

1 A1010 Shoes 01/09/2015 200 210
2 A1010 Shoes 01/10/2015 200 190
3 A1010 Shoes 01/11/2015 200 205
4 A1010 Shoes 01/12/2015 200 170
5 A1020 Boots 01/09/2015 50 75
6 A1020 Boots 01/10/2015 50 65
7 A1020 Boots 01/11/2015 50 70
8 A1020 Boots 01/12/2015 50 47
9 A1030 Trainers 01/09/2015 90 105
10 A1030 Trainers 01/10/2015 90 102
11 A1030 Trainers 01/11/2015 90 85
12 A1030 Trainers 01/12/2015 90 88

 

Dimension Table PRODUCT

PRODUCT

product_id description
A1010 Shoes
A1020 Boots
A1030 Trainer

 

SAP HANA Rules Framework Artifacts

Vocabulary

I have represented the fact and dimension table in an SAP HRF vocabulary called sales. The vocabulary maps all the elements of both tables into data objects “saleshistory” and “product” respectively and uses a one to many association between product and sales history.

Rule Service

I then create a rule service called “Sales Analysis” by defining it with the following properties: –

/wp-content/uploads/2016/03/thumbnail1_904810.png

In particular I make sure that the Consumption Artifact is of type “View” and the Resulting Data Object is “product” with keys “product_id” and “description”.

The “View” Consumption Artifact is important as it dictates SAP HRF create a HANA column view to hold the rule determination result. This view is stored in the Column View folder of the SAP_HRF database schema. This view is created in the format “<package>::<rule service name>.VIEW”. As I created my SAP HRF application in the package “sap.demo-store.sales.resources” my view is referenced by the name “sap.demo-store.sales.resources ::Sales Analysis.VIEW”

The “Resulting Data Object” allows me to specify the business entity I wish rules to be evaluated against. I have chosen the data object “product” so that I can analyse the sales results for my individual products.

I also provide an output called “SalesQuantity” – for “View” artifacts an output is mandatory. By specifying an output in the rule service that I defined in my vocabulary it allows me to view my rule results in the SAP HRF Fiori UI whilst also providing context to the results. The output contains two integer input parameters “Budget_Quantity” and “Actual_Quantity”.

Rule

My rule is entitled “Sales Below Budget” and for simplicity is a text rule rather than a decision table rule. The objective of this rule is to evaluate those products where the average sales quantity over a period of time is less than the equivalent budget sales quantity over the same period. I initially set the time period to be over the last sales month so that the rule condition and output parameters look like those below

/wp-content/uploads/2016/03/thumbnail2_904814.png

I have set my outputs so that they provide the average sales quantity figures across Q4

Rule Determination

When I test the rule service in the SAP HRF Fiori UI the rule determination engine provides 3 results, one for each product. December was a poor month for sales as all product sales quantities fell below their budget values.

/wp-content/uploads/2016/03/thumbnail3_904815.png

So now you ready to read to the second part in order to learn how to visualize the results with SAP Lumira…

To report this post you need to login first.

6 Comments

You must be Logged on to comment or reply to a post.

  1. Sandeep Sharma

    Hello Noam

    This is very helpful scenario to help us understand on how to extend the HRF .

    Please help with the JAM page access on this and PDF mentioned as we would want to develop this to gain insight . We are using HRF in a custom process for a client and this blog is the closest that fits the bill.

    (0) 
        1. Noam Gilady Post author

          Hi Sandeep,

          Sorry! Apparently our Jam page is opened for SAP employees only. We are checking how we can assist you with your requirement.

          BR, Noam

          (0) 

Leave a Reply