Skip to Content
0
Feb 05, 2019 at 11:21 PM

IES 10901 :: universe prompt with multi value throws error

819 Views

Prompt: <SQL Query> where RISK_BU in (@prompt ('Select Business Units:', 'A','Risk\Business Unit',multi,free,persistent,{'Challenger'}))

Error: The following database error occurred: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ','.. For information about this error, please refer to SAP Knowledge Base Article 2054721 on the SAP Support Portal. (IES 10901) (Error: INF )

Details: If user upon running the report select a single value (even if the 4th parameter of prompt says multi) it works fine. If user selects multiple values (which it is meant to work) it throws the above error. I could not find any knowledge base article after hours of digging. Any help on this is highly appreciated.