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

[DmitryKuznetsov · 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