Question Re: How do I should use Input Parameters with multiple values on a scripted CalcView? in Technology Q&A

How do I should use Input Parameters with multiple values on a scripted CalcView?

Former Member — Mon, 29 Dec 2014 20:08:39 GMT

Hi,

I need to make some projections on a scripted Calculation View with several values in the where clause of a CE Function using multiple values from an Input Parameter. I found the way to set intervals or single values but nothing like what I'm looking for.

In SQL it should be something like:

SELECT ATTR1, sum(MEASURE1) FROM "<calc_view>" PLACEHOLDER ( "$$MONTH$$", ['val1','val2','val3','val4']) GROUP BY ATTR1;

Or like SELECT-OPTIONS in ABAP.

Does scripted calculation views have a way to filter a table by a field with several values using Input Parameters?

How do I set the Input Parameters to reach that?

How is the syntax to call that calculation view and set several values in the place holders?

Thanks!

Re: How do I should use Input Parameters with multiple values on a scripted CalcView?

amol_samte — Tue, 30 Dec 2014 04:13:30 GMT

As of now input parameter does not support for multiple values like select-options in abap, but you can use input variable for achieving the same.

Regards,

Amol

Re: How do I should use Input Parameters with multiple values on a scripted CalcView?

Former Member — Tue, 13 Jan 2015 15:03:09 GMT

Thanks Amol!

Finally I've used variables instead input parameters that allow me to filter by multiple values.

But I wanted to use Input Parameters because I can filter values from views sooner and not calcute over values that will be filtered at the end. It would be more performant.

Re: How do I should use Input Parameters with multiple values on a scripted CalcView?

amol_samte — Mon, 19 Jan 2015 10:22:46 GMT

Hi Ivan,

Actually we had also same issue with date i.e. we have to pass date value like from date an to date.

So we have created IP_FROM_DATE and IP_TO_DATE input parameter.

Regards,

Amol

Re: How do I should use Input Parameters with multiple values on a scripted CalcView?

Former Member — Mon, 19 Jan 2015 10:55:03 GMT

Hi Ivan,

First of all, input params are not meant for filtering. And there is no direct way to pass multiple values to a input param.

But if its a critical requirement there is a way. But will require some work around.

Pass your values to one single input param seperated by a comma or something. Then in your script parse it and store it separately in different variables. Hope this helps you.

Regards,

Safiyu

Re: How do I should use Input Parameters with multiple values on a scripted CalcView?

DmitryKuznetsov — Thu, 21 May 2015 06:33:04 GMT

Amol,

I am working on something very similar. I have a logic for the dates, then I get IP_MONTH_FROM and IP_MONTH_TO as two separate Input parameters.

Next, I would like to fill the Default Values of one Interval Variable with those input parameters. The question is, how to? In other words, what is the syntax for something similar to RANGE-LOW and RANGE-HIGH in CMOD in BW?

Thanks in advance for your insight.

Dmitry

Re: How do I should use Input Parameters with multiple values on a scripted CalcView?

Former Member — Thu, 21 May 2015 07:25:20 GMT

Hello Ivan Cernigoj,

Please go through this guide by Krishna Tangudu

,he explained it beautifully I hope it will solve your problem

and

Regards

Debasis Nayak

Re: How do I should use Input Parameters with multiple values on a scripted CalcView?

Former Member — Tue, 26 May 2015 17:41:36 GMT

Thanks,

I finally did that.

Regards,

Iván