Problem with FS Command

Hi

I created two filters, the result of the selection is passed as parameter to the Web Intelligence using the FS Command.

In Web Intelligence I put two filters to prompt, example - " Filter 1 = Vendor " - "Filter 2 = Product" and value total.

I would submit data when the user selects only the Vendor (the Vendor and all their products), but I have two dimensions with "AND" it becomes impossible. If I replace the "AND" for "OR" Vendor of the filter (FS Command) don´t work. Following is the query that the Web Intelligence:

SELECT

Table__1."Vendor",

Table__1."Product"

FROM

"Sheet1$" Table__1

WHERE

(

Table__1."Vendor" = @prompt('Vendor','A','DimensoesVendor',Mono,Free,Persistent,,User:0)

AND

Table__1."Product" = @prompt('Product','A','DimensoesProduct',Mono,Free,not Persistent,,User:1)

)

In the Xcelsius I´m using FS Command

="&lsSVendor="&J1&"&lsSProduct="&K1

Do you know any solution for this problem?

Thank you.