Tuesday, November 29, 2016

Decision Tables

Hey guys,

   Summary of the Decision Table Blog:  https://archive.sap.com/discussions/thread/3488033


  1. Can be used to restrict a measure based on certain conditions of the master data

    1. Columns: describe the definition and operation of the rules
      1. Condition Column – definition of the rule
      2. Action Column – operation to the performed if the conditions are satisfied.
    2. Rows: represents the value associated with these definitions and operations respectively.

Decision Tables:

  1. formulate rules of business, company or corporation in a table structure
  2. Business rules articulated in form of decision table are quick to understand, clean, crisp, readable and most importantly compressed.
  3. a very powerful style to represent business rules which otherwise would have spanned over multiple rows, pages and screens

What are decision Tables made of:
  1. Columns: describe the definition and operation of the rules
    1. Condition Column – definition of the rule
    2. Action Column – operation to the performed if the conditions are satisfied.
  2. Rows: represents the value associated with these definitions and operations respectively.
  1. Evaluated column-wise from left-to-right AND fashion.
  2. Action value associated with a row – whose conditions are satisfied – are collected in the result set
    1. the Customer.IDcolumn value is evaluated first
    2. followed by Customer.CurrentBalance in AND fashion
    3. If the conditions are met then Customer.Type is set to Gold or Silver.

This has created a benchmark by debuting business rules in database layer. Information modeler, data architects or application developers can now update or select the data from the database tables with basic understanding of SQL language – A language that manages database.

Business rules in this avatar offers a high degree of decision making capabilities with big data.;

writing business rules that aids better decision making with big data and performing analytics over the results –Business Rules powered by SAP HANA is the answer


No comments:

Post a Comment