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?

[former_member594385 · Accepted solution]

Hi Manoj,

Following things might have happened in your calculation view.

As there are two input parameters(IP1,IP2) are applied on the same Attribute i.e. Period BETWEEN operator might been used.

Also please check how the input parameter mapping to PERIOD attribute happened in the view.

Please share the filter expression screenshot to point out the exact issue.

Currently, in your model is is using BETWEEN operator instead of EQUAL because you are applying the filter on same Attribute.

Thanks,

Jay.

[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 .

[former_member327592]

Thank you Konrad.

[KonradZaleski]

Please upvote if my answer was helpful for you.

Thanks!

[former_member327592]

Thank you Jayashankar and Florian.

There is a filter in the model between is used . That explains the ansers.