Input Parameter with no Value

[former_member193552]

Input Parameter with No Value

Issue:

I have input parameter IP_Div. If I input division value? I get out put in HANA data preview. If I decide to leave input parameter blank and expect retrun results for all divisions, I don’t get any record. It seems it does not like me leaving input parameter blank.

Please see attached screen to see how input parameter filled returns value but leaving it blank does no return any value.

But When I Want to leave it blank to see data for all divisions? I don't get any records.

[pfefferf · Accepted solution]

Hello Faisal,

I think you have "just" a simple filter expression which compares your parameter IP_Div against your Division column. In case of an empty division parameter that filter expression is not ignored and all values are filtered out, cause no one is blank.

To get your values you have to adjust your filter expression, to consider that case. For instance like following:

if('$$IP_Div$$' = '',match("Division",'*'),match("Division",'$$IP_Div$$'))

I used "Division" as your column name (if you renamed it for the output please adjust it to the name you have available in the data source).

Regards,
Florian

[former_member533736]

Hello, you can use a variable type parameter, this will comply with all cases, whether it has value or not. But it is only applicable in the semantic layer, that is, you will not be able to make filters in the projections, this can affect the performance.

[former_member193552]

Hi Florian, if we have input parameter with multiple input values? then will we need to change else condition with "In" instead of Match?

[pfefferf]

Yes. Match handles only one argument.

[former_member669158]

Could you make it work with input parameter with multiple entries? Thanks!