Interactive education offers concise, simple and effective way to learn how-to build applications using SAP HANA. It is used to mean a little more than reading through guides and takes you to an interactive journey with a whole new experience of stimulating information for application.

SAP HANA has launched this new generation comprehensive learning technique named SHINE (SAP HANA Interactive Education) – for anyone who wants to use SAP HANA in their applications. As part of this interactive learning, a pre-delivered demo application(s) are available with SAP HANA toolkit – which makes your first SAP HANA XS application just few clicks away from having been running in your environment – giving you to an early look inside database tables, sequences, attribute view, analytical view, calculation view, decision tables, OData services, Server side java script (xsjs), SAPUI 5 …etc. and provides you an opportunity to learn about many more artifacts and functionalities of SAP HANA.

In SAP HANA SP07 release, SHINE is bundling a demo application, on Enterprise Procurement Model, as Delivery Unit (DU) – with complete database structures, sample data, developer information models and application logic. This demo is prepared such that you are engaged with all the major building blocks required to build an application in SAP HANA. In this application, Business Rules in SAP HANA – Decision Table has been used to formulate rules that calculate discount on the Orders based on Region and Sales.

To do so,  a table type is used to design decision table –> the generated column view of the decision table is consumed in scripted calculation view to get the discount based on regions –> finally the discounts from every region is aggregated into Sales Order. So for a given the company and region, the discount is been calculated for that region and applied to Sales Order which goes to the Invoice of the procurement model.

Decision table is built on table type such that single table can calculate discounts based on regions. The table type looks like –

Image_1.jpg

Decision table is modeled on the input from table type as Conditions and DISCOUNT Parameter as Actions as –

Image_2.png

The decision table is then consumed in Scripted Calculation View for all required Input

Image_3.jpg

This Scripted Calculation view is used in Graphical Calculation view as Projection to get discount on various regions like EMEA, APJ etc –

Image_4.jpg

Finally it is consumed in XS application as service and you can use the sales dashboard to see the statistics of discounts based on regions. Have a look at few snapshots here –

Image_5.jpg

Image_6.jpg

Image_7.jpg

Decision table – embedded in SHINE demo application – is available with SAP HANA SP07 release. Enjoy running and exploring this demo application for hands-on experiment by harnessing your knowledge to get the real time feel of the power of SAP HANA and to brush up your information for better indulgence with the product. For more information on the demo application read through the SAP Help Guide > SAP HANA Interactive Education (SHINE). Write to me or open a support ticket on BC-DB-HDB-XS component if you have any queries on SHINE.

To report this post you need to login first.

3 Comments

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

Leave a Reply