Decision Table (DT)in SAP HANA
As per the SAP HANA Developer guide Decision table is again a strong features of SAP HANA in memory Data base.
This features come in bundle of SPS05 on wards.
In a simple language if we try to understand a decision table is a table which will take a decision to retrieve/update a data based on the business rules.
We can write our business logic in a simple excel file and upload in to the decision table. A non technical guy could also do these task behalf of a application developer if his/her Business idea’s are clear.
There are few steps to create Decision table(DT).
1.Go to the Modeler view create a package.
2.Once you right click on package will find Decision Table just click on that and one pop up appears.
3.Give any name to your Decision Table and click Next and finish.
4.In studio you will find DT panel (left and right panel of DT). Drop a table from your schema into left panel.
5.Create your Data foundation ,right click on columns and add as a Attribute.
6.Remember Decision table needs two mandatory parameters 1.Conditions 2. Actions
7.Conditions and actions could be a anything from vocabulary (Attributes ,Parameters).
8.Add some attribute as a conditions and add parameters as a actions.
Here we have to focus one more thing that is Parameters (?)
a right click on parameters and click on new
b.Give user define parameter name and select Data types of parameters.
c.Now your parameters is ready to be a part of actions.
10.In left panel bottom you will find two tabs 1.Data Foundation 2. Decision table .
click on Decision table and provide some business rules according to your requirement.
11.You can select dynamic value for your conditions and for actions.
12.just click on Decision table conditions or actions you will find add add dynamic values.After providing specific condition you can use Alt+Enter .
13.If you want to apply your business rules on every table’s column then use *.
14.Just find some screen shots of Decision table and rule excel file.
I hope above steps will help you to create a Decision table without any hurdle.