O'Reilly logo

SAP HANA Cookbook by Ganesh Mahadevan V., Chandrasekhar Mankala

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required