How do I should use Input Parameters with multiple values on a scripted CalcView?
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?