How To Use Decision Table In Calculation View In SAP HANA
A decision table is an excellent tool to use in both testing and requirements management. Essentially it is a structured exercise to formulate requirements when dealing with complex business rules. Decision tables are used to model complicated logic. They can make it easy to see that all possible combinations of conditions have been considered and when conditions are missed, it is easy to see this.
First create the EMPLOYEE table with following data
Create New Decision Table and select EMPLOYEE table in the Data Foundation
Make SALARY column as Condition and create new parameter HIKE make it as Actions.
Click on Decision Table and give the conditions like below.
Now Create Calculation view and select EMPLOYEE Table and EMPLOYEE_SALARY Decision Table
In EMPLOYEE table select all columns, from EMPLOYEE_SALARY Decision Table select all columns.
In Join join the EMPLOYEE Table ID with EMPLOYEE_SALARY Decision Table ID and select the Below fields.
Create one calculated Columns new_salary for displaying after hike salary.
Select below columns in Aggregation.
Save and Activate the View