Error while passing multiple values input parameter to HANA Calculation View

[akshinde]

Hi I am trying to pass multiple values to Input Parameter PLANVERwhich is Multiple Entry Enabled, i am filtering this multiple entered parameter inside the Filter Expression using following expression

in("PLANDATE",rightstr('$$PLANVER$$',10))

While running this through AFO and passing multiple input entries as well as while running through sql i am getting following error.

SELECT "PLANNINGVERSIONNAME", "PLANDATE", "Z_PLAN_DATE", "PERIODID", "WEEK_SEQ_NO", "PRODUCT", "LOCATION", "Z_PLAN_HZ_WEEK", "MONTH_SEQ_NO", "PLANNINGVERPLUSPLANDATE", sum("FORECASTCONSTR") AS "FORECASTCONSTR" FROM "_SYS_BIC"."FlowGraph/CA__TEST_MULTIPLE_ENTRY"('PLACEHOLDER' = ('$PLANVER$', '''BASE_2019-03-11''')) GROUP BY "PLANNINGVERSIONNAME", "PLANDATE", "Z_PLAN_DATE", "PERIODID", "WEEK_SEQ_NO", "PRODUCT", "LOCATION", "Z_PLAN_HZ_WEEK", "MONTH_SEQ_NO", "PLANNINGVERPLUSPLANDATE"

error while passing multiple iput parameter Caught exception : exception 70034023: Instantiation of calculation model failed \$message\$= Instantiation of calculation model failed;exception 306002: An internal error occurred (42014)

[KonradZaleski · Accepted solution]

First of all, if you are using multi value input parameter you should not use single quotes when defining parameter. Secondly you cannot apply functions on multi value input parameters (they are allowed only for single value parameter). Valid expression should be as follows:

in("PLANDATE",$$PLANVER$$)

[akshinde · Accepted solution]

thanks Konrad for your quick response