Now you can import or export your excel sheet to a Decision Table!
In most case scenarios like in –
a. making a region based calculation of rate;
b. calculation of score based on certain factors like experience, qualification, etc.,
c. setting of discount based on user capacity and trustworthiness
where sets of value matching needs to be maintained in a form of a table, an excel sheet is an even more accessible option for business users when compared to a maintaining a decision table in NWDS BRM component.
With this new plug-in provided – link – you will be able to group the required rules i.e., create the required value matching peacefully by making use of a excel sheet without having to undergo the hassle of having to install the NetWeaver Development Studio for this purpose exclusively. This excel sheet once created or modified can then be imported into your rules DC as and when required.
For doing this, you need to note that –
- The header structure of the tables should be the same in both the excel sheet as well as the decision table.
- If the decision table contains Other Conditions values or complex expressions in action values, it can be exported, but cannot be imported due to limitations in parsing the mathematical expressions.
- The excel document which can be imported needs to be MS Office 2007 compatible.
A best practice method described in this document is to create the decision table with the required header structure and export this into a .xlsx file. It is recommended to make the required modifications to this excel sheet and import it back.
To help you in installing and using this plug-in a clear step-by-step document has been provided in the SAP NetWeaver Business Rules Management Resources Center.