This document is prepared based on SAP HANA Version SPS05 Revision 47.
While creating the decision table we will specify Conditions and Actions.
If the conditions on an attribute are not specified in proper order then while validating, we get error.
In one of my previous documents I showed how to create decision table and used conditions in an order such that while validating it should not throw any error. I would like to request you to go through my previous document, if you had not seen before. Click here
In Step 9 of that document, there is a screenshot with number 5 enclosed in a circle, where the condition on attribute (SAL) is in proper order and the same screenshot is pasted below.
Now let us change the second condition to SAL > 9001 as shown below and validate the decision table. Below is the result of validation
The error is due to missing range found in second condition of SAL attribute.
What missing here is there is no condition for SAL = 9001 in the above two conditions.
While modeling for a requirement there is a chance that there will be no business rules for some of the scenarios and hence we can avoid those while creating decision table.
Actually while validating, in the background there are many validation rules which goes through and we can find those validation rules by navigating through Windows -> Preferences -> Expand Modeler -> Click Validation Rules.
We will observe that under Decision Table section, “Decision Table Check Consistency Rule” is checked. To avoid the validation error on missing range, uncheck this validation rule and click ok.
Now again validate our decision table and this time, status will be Completed Successfully.
Its just a small trick