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.