Question Re: sap hana input parameters- Range in Technology Q&A

sap hana input parameters- Range

former_member327592 — Thu, 25 Oct 2018 21:17:01 GMT

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

Re: sap hana input parameters- Range

pfefferf — Thu, 25 Oct 2018 22:29:52 GMT

Can you please show your filter expression?

Re: sap hana input parameters- Range

former_member594385 — Fri, 26 Oct 2018 05:25:05 GMT

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.

Re: sap hana input parameters- Range

KonradZaleski — Fri, 26 Oct 2018 08:31:59 GMT

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:

Re: sap hana input parameters- Range

former_member327592 — Fri, 26 Oct 2018 08:45:52 GMT

Thank you Jayashankar and Florian.

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

Re: sap hana input parameters- Range

former_member327592 — Fri, 26 Oct 2018 08:48:11 GMT

Thank you Konrad.

Re: sap hana input parameters- Range

former_member327592 — Fri, 26 Oct 2018 08:48:44 GMT

Thank you Konrad.

Re: sap hana input parameters- Range

KonradZaleski — Fri, 26 Oct 2018 09:05:43 GMT

Please upvote if my answer was helpful for you.

Thanks!

Re: sap hana input parameters- Range

former_member327592 — Fri, 26 Oct 2018 11:48:24 GMT

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 ?

Re: sap hana input parameters- Range

former_member327592 — Fri, 26 Oct 2018 11:52:11 GMT

Hi Konrad,

Thanks . I have now upvoted .