Prompts and derived tables

[huggyd]

BOXi R2 SQL Server 2005

I have a derived table in my universe design that is a select from a SQL Server function. I am trying to set up a prompt that will allow me to pass multiple values the function's parameter such as a list of sites.

The prompt is set to the following:
@Prompt('Select Site Codes', 'A','Site\Site Code', multi, free)

When I try to check the syntax I get the particularly unhelpful message
Exception: DBD,[Microsoft OLE DB Provider for SQL Server] : Incorrect syntax near ','.State: 42000

If I set the prompt to mono instead of multi thw syntax is passed. Have I reached a limitation of data sources for BO universe tables??

 

[blom0344]

Do you mean a user defined function (UDF) in SQL server?
An UDF will only accept one value at a time when it is adressed.
Please post function syntax and derived table SQL..

Ties Blom