IES 10901 :: universe prompt with multi value throws error

[former_member602483]

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.

[former_member236552]

I just came across this same issue on a Free Hand SQL Webi in 4.2 sp8 patch 600. Anyone have any insight?

[TuncayKaraca]

Hi Susan, did the answer below help?

[TuncayKaraca]

Hi Susan,

It seems SAP KBA 2303826 - Error "[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near “,”.. ... is describing the same issue. You can take a look into it.

Cause: No need to put parentheses around the prompt definition. When running the query, the system will add those parentheses automatically.

Resolution: Eliminate the parenthese around the prompt definition :

Example:

select customer.country from customer

where customer.country in @prompt('Buyer (O):','A',,Multi,Free,,,)

Thanks,
Tuncay Karaca