## Friday 6 October 2023

### Multiple Input parameter in Hana Calculation graphical view

Aim: To create a calculation view with multiple input parameter that should display data corresponding to the input parameter.

The entire calculation view is here,

Step 1

◉ It is necessary to create a Input parameter in a calculation view to get input from the user.
◉ In our case, I created input parameters for Company code, Date and Profit centre.

Step 2

◉ In our case I m going to get multiple inputs for Company code and Profit centre.
◉ Make sure that you have enabled the Multiple Entries option while creating and defining the Input parameter.
◉ You can also provide default values here itself.

Step 3

◉ To achieve multiple input parameter, it is necessary to filter the input parameters in the filter expression.

Step 4

Syntax:

(in(“field name in table”, \$\$ Input parameter \$\$) or match(“field name in table”, \$\$ Input parameter \$\$)) and (in(“field name in table”, \$\$ Input parameter \$\$) or match(“field name in table”, \$\$ Input parameter \$\$))

Expression formula in our case:

(in(“BUKRS”, \$\$Company_code\$\$) or match(“BUKRS”, \$\$Company_code\$\$)) and (in(“PRCTR”, \$\$Profit_centre\$\$) or match(“PRCTR”,\$\$Profit_centre\$\$))

Explanation:

• It is possible by using in() or match ()
• In (): It is used to filter the data by condition of the input data is IN the table => display those data.
• Or: It allows to check two conditions.
• Match (): it is used to filter the data by condition of the input data is MATCH any entires in the table => display those data.

(in(“BUKRS”, \$\$Company_code\$\$) or match(“BUKRS”, \$\$Company_code\$\$)) and (in(“PRCTR”, \$\$Profit_centre\$\$) or match(“PRCTR”,\$\$Profit_centre\$\$))

• \$\$Company_code\$\$ – Input parameter that we created.
• “BUKRS” – company code field name in the table.
• \$\$Profit_centre\$\$ – Input parameter that we created.
• “PRCTR” – profit centre field name in the table.

Step 5

Executing for

Date: 201812

Company Code: 3000

Company Code: AJSC

Profit Centre: 0000001000

Profit Centre: 0000002000

Profit Centre: 0000003000

Output

Data filtered successfully for the corresponding input parameter.