Skip to Content
Author's profile photo Archana Shukla

Use Microsoft Excel to Manage Decision Table in SAP HANA

In my previous blogs I introduced the capabilities that can be used by the information modeler, data architects or application developers to model the decision table in SAP HANA Studio. Writing business rules in form of decision table from HANA Studio requires knowledge of SQL, which business users do not possess, I here introduce mechanism which are used by Business Users to manage their business rules.

Microsoft Excel is well known tool to Business Users that they use in day-to-day life to manage their business rules and data. Working with excel document to modify the rules have given the users to access, edit and view decision table in an easy-to-use, powerful and handy tool – that you can open from your desktop, phone or web. You do not need to be geeks or technical experts or possess any essential skills to amend rules. 

Some facts about managing business rules using Microsoft Excel –

  • Supported version – Microsoft Excel version 2007 onwards
  • By default, the decision table is exported by name:
       <decision-table-name>_<date>_<time>.xls or xlsx where date format is DDMMMYYYY and time format is HHMMSS [HH is 24 hours]
  • In Microsoft Excel you can –
    • Add or delete rows
    • Change value of the condition and action cells
      • Add or modify static values like change 100 to 2000 or > 3000 etc.
      • Add or modify expression with only static values like ((10 + 20) * 100) etc.
  • In Microsoft Excel you cannot
    • Change cell values to add or modify dynamic expression
    • Change the structure by adding/deleting/modifying the condition or action columns

Here is the flow that is insight to manage decision table using Microsoft Excel. Starting from left in clockwise manner

    1. An information modeler, data architect etc. created the decision table in HANA Studio
    2. He exports the data to local or shared directory in form of Microsoft Excel
    3. Business users access this excel document and modifies the rule
    4. Information modeler, data architect etc. again imports the changed excel data back to decision table
    5. Finally, he activates the decision table to bring in affect the changes at application level


          Figure 8.1 – Flow that shows Import-Export decision table with two personas – Technical developers and Business users

The ability to manage rules using Microsoft Excel can be huge advantage because business users are already aware of this tool and they can update the rules without the need for HANA Studio or any knowledge on technical or database language.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Graham Johanson
      Graham Johanson



      How would this work in a production environment where we didn't want to hand off the excel upload to the technical developer?  Is there an option to upload without the user needing to access the decision table directly in HANA studio?



      Author's profile photo Archana Shukla
      Archana Shukla
      Blog Post Author

      Hello Graham,
      Why would you want to change the decision table in production system. Ideally all the decision modelling must happen in DEV system via HANA Studio and then transported to Production system.

      If you are looking for user interface for Business Users, then you must look for SAP HANA Rules Framework, which works on similar principals and provide Fiori based user interface for business users to easily manage the rule.