SAP HANA Cookbook

Creating decision tables

Decision tables help users who don't have the required SQL knowledge. This recipe tells you how to create decision tables.

Getting ready

Decision tables can be created on a procedure, table, or any SAP HANA model (attribute/analytic/calculation view). Hence, before starting to create decision tables, we must have a SAP HANA artifact.

To create decision tables, the _SYS_REPO user must possess the SELECT, UPDATE, and EXECUTE authorizations with the GRANT option on the schema, which has the table/procedure that is used for the creation of a decision table. If a decision table is created on top of the SAP HANA model, the authorizations discussed should be present on the schema which holds the tables used in the view creation. ...