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:
Table__1."Vendor" = @prompt('Vendor','A','DimensoesVendor',Mono,Free,Persistent,,User:0)
Table__1."Product" = @prompt('Product','A','DimensoesProduct',Mono,Free,not Persistent,,User:1)
In the Xcelsius I´m using FS Command
Do you know any solution for this problem?