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

[Former Member]

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!

[amol_samte · Accepted solution]

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

[Former Member · Accepted solution]

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.

[amol_samte · Accepted solution]

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

[dmitry_kuznetsov1 · Accepted solution]

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

[Former Member]

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

[former_member210482]

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

[Former Member]

Thanks,

I finally did that.

Regards,

Iván