Ejemplo de query para el Dataset del filtro:
SELECT DISTINCT ProductCategoryKey AS CategoryKey, EnglishProductCategoryName AS Category FROM DimProductCategory UNION SELECT -1 AS Expr1, 'Todos los valores' AS Expr2 ORDER BY Category
Ejemplo de query para Dataset con Datos::
DECLARE @p int SET @p=-1 SELECT Product, SubCategory, CategoryKey, Category, CostAmount, SalesAmount, OrderQuantity, Month, MonthNumberOfYear, Year FROM vProductProfitability WHERE ((Year = 2003) AND (MonthNumberOfYear IN (1, 2, 3)) AND (CategoryKey IN(@Category) OR (@p IN(@Category))))