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!

[Former Member]

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