VARIABLES IN SAP HANA CALCULATION VEW

Variables are the dynamic filters which needs to be applied on the final result (i.e. User can provide the filter during the runtime of the execution).

HOW TO CREATE VARIABLES

To Create variables click on the Semantics and go to Parameter/Variable tab and click on the PLUS Sign.

Variable creation

In the new variable creation widow, we need to give the Variable name, Label(Description) and the attribute  the field where the dynamic filter going to be applied and the selection type needs to be mentioned

• Single Value
• Interval
• Range

We can also mention whether multiple entries are allowed for this variable and whether this variable is mandatory based on the requirement.

For our understanding I have created HANA View on top below table with variable on Plant.

Data without variable

    Entering PLANT = 1000,2000 as variable

Now records with plant 1000 and 2000 alone got filtered.

We will see about creation of input parameters and difference between variables and input parameters in SAP HANA in next post.