Skip to Content
avatar image
Former Member

Creating decision table in HANA studio

Hi Experts,

       Can any one help me on,

          What is decision table?

          What are the advantages of using decision table?

          How to create decision table?and also give me one sample scenario

Regards,

Hityshi Gullipalli.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jan 22, 2014 at 07:14 AM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 04, 2014 at 08:11 AM

    Hi Hityshi,

    Answer to your first question:

    What is decision table?

    Decision table is a way in business rules realm to formulate rules of business, company or corporation in a table structure.

    In concept, decision table comprises of columns and rows where columns describe the definition and operations of the rules and rows represents the value associated with these definitions and operations respectively. The columns are thus classified as 
    (1) Condition Column – definition of the rule (2) Action Column - operation to the performed if the conditions are satisfied.

    For Example: Let us assume that there is rule in bank credit card department which says, IF the Customer.ID = CUST_120000 has Customer.CurrentBalance Greater Than 2,000,000, THEN set Customer.Type = Gold ELSE set Customer.Type = Silver. This flat rule can be represented in tabular form as:

    Customer.ID

    Customer.CurrentBalance

    Cutomer.Type

    CUST_120000

    >2000000

    Gold

    CUST_120000

    <= 2000000

    Silver

                         Figure – 1.1: A decision table to set the Customer type in Credit Card department

    About your second question:

    What are the advantages of using decision table?

    While Business rules in tabular format is not new and has been a known concept in market for quite a long time - what we introduce here is decision tables integrated to SAP HANA – a modern in-memory platform. 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. Decision table exported as Microsoft Excel can later be used by Business users to manage the rules . Business rules in this avatar offers a high degree of decision making capabilities with big data. It advertently inherits real time-performance benefits that SAP HANA offers making it even more powerful, optimized and real time reliable.

    Hence, when you think about 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.

    About your 3rd question: How to create decision table?

    Have a look at this short video, and then follow it. It is very very simple scenario, but it will be a good start.

    HANA Academy - Creating Decision Tables with return values - YouTube

    Hope you find this helpful.

    Cheers,

    Mariano

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 22, 2014 at 09:24 AM

    Dear hityshi gullipalli   as Krishna Tangudu  said " It would be better if you have done simple search before posting your question."

    1. Search before you post. There are many answered questions and helpful postings already in SCN. Before posting a new question, please search SCN to see if it’s already been asked / answered. That’s the fastest way to get your information.


    ( Taken from  The SCN Rules of Engagement | SCN )


    regards

    poorna

    Add comment
    10|10000 characters needed characters exceeded