cancel
Showing results for 
Search instead for 
Did you mean: 

Creating decision table in HANA studio

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

former_member182302
Active Contributor
0 Kudos

Hi Hityshi,

It would be better if you have done simple search before posting your question.

There are many documents on Decision tables. Here are a few:

HANA Academy - Creating Decision Tables with return values - YouTube

SAP HANA Elearning -- How to create Decision Tables with update values - YouTube

Regards,

Krishna Tangudu

Answers (2)

Answers (2)

Former Member
0 Kudos

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

Former Member
0 Kudos

Dear as   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