Input Parameters in SAP HANA

Input Parameters are used to Filter the data dynamically in any node of the calculation view and also perform calculation based on the dynamic input from the user.

Let us consider a scenario where we need to restrict the CALMONTH (i.e user will define which CALMONTH data should display at the run time). And also the Pass Mark will be decided by the user at the run time of the calculation view.

Please find the below sample data we have without implementing Input parameter.

Now goto Parameter/Variables table in semantics. Click the ‘+’ sign and select create Input parameter.

Input parameter for pass mark:

Input parameter for CALMONTH filter:

When can also mention whether Input parameter whether it is going to be mandatory or not in the new input parameter creation window.

Crating new calculated column to filter on calmonth data

Filtering on calmonth in projection 1

Calculated column for pass/fail status based on passmark_ip

Now activate the Hana view and give display preview in semantics

Below is the output of the view

DIFFERENCE BETWEEN INPUT PARAMETER AND VARIABLE IN SAP HANA CALCULATION VIEW:

• INPUT PARAMETER is used to do any calculation or filter on any node based on the dynamic input given where as the Variables is used to do dynamic filter on the final result of the hana view
• We can set Data type of the Input parameter where as variable is bound to attribute of the view

We will see about usage of RANK Node in the next post