Multi-Sheet Decision Tables allow you to take complex business requirements and break them down into constituent sets of business rules. It does this by allowing you to have multiple decision sheets with the formula. This can useful for both making your Decision Table logic more readable as well as separation of different entitlement criteria.
For this article it is assumed that you have at least basic familiarity with Decision Tables and/or have read the following articles:
Note: We will not detail step-by-step instructions here on how to set up Conditions or Actions, please read the above articles if you need detailed configuration steps.
Setting up a Multi-Sheet Decision Table
To create a Multi-Sheet Decision Table you click on Commands and then on Toggle Editor as you would for a standard Decision Table.
This will open up the standard Decision Table canvas.
As you can see from the above screenshot you now have 3 sheets on the Decision Table.
- Decision Table
To rename a Decision Sheet double click on the sheet name.
The text will become editable and you can enter the new name for the sheet.
Once the sheet is renamed just click off the field and the sheet name will be changed to the new value.
Decision Table Calculations
Each Sheet in the Multi-Sheet Decision Table can generate results and these may need to be accessed from other Sheets.
These will show up under the Decision Table Calculations node on the Source tab of the configuration pane.
These are separate and distinct from regular Calculations.
How to set up Decision Table Calculations
- Name your Action something meaningful
- Right-click on the Decision Table and select Operations > Toggle Advanced Mode
- Row 3 will appear on the Decision Table Sheet
- In the cell below the Action Name type in "=="
- This will mark this Action as a Decision Table Calculation
- This Action Name will now appear in the Decision Table Calculations node of the Source tab
Copying Entire Decision Table Sheets
It is possible to copy an entire Decision Table Sheet within the same Multi-Sheet Decision Table.
To do this:
- Right-Click on the Decision Table Sheet to bring up the context-menu
- Hold down the CTRL key on your keyboard and click on Cells > Copy from the context-menu
- The entire Decision Table Sheet will be duplicated