sap hana input parameters- Range

[former_member327592]

Hi ,

I have a query on input variables how they work .

I have created two input variables(Variable 1 and Variable2) on YearPeriod and used as IP in Calculation view.

When I tried to view the data in Data preview from 2018002(IP1) to 2018004 (IP2), data also displayed for 2018003 also along with 2018002 and 2018004 which means it is taking as 'Between' operator instead of 'Equal 'operator . Just wondered where and how this Between operator is taking place .

Appreciate any advice .

Thanks

ip1.png

ip2.png
ip3.png

ip4.png

ip5.png

[pfefferf]

Can you please show your filter expression?

[KonradZaleski]

Hi Manoj,

1. It would be better if you provide us also filter expression for that two input parameters, but to achieve what you want using two input parameters the filter expression should look as follows:

2. Optionally you could create only single input parameter of Multiple Entries type:

And in filter expression apply it directly on YearPeriod column (notice that single quotes are applicable for that kind of parameter)

When you open your report you can provide multiple entries for that input parameter:

[former_member327592]

Thank you Konrad.

[former_member327592]

Hi Konrad,

Yes. Your answers are very helpful. How to Upvote ? I can not see option to Accept answer . Is this because i can only accept one answer in a thread ?

[former_member327592]

Hi Konrad,

Thanks . I have now upvoted .