Sunday, June 9, 2013

Changing parameter values in SSRS on SSAS Cube

Create a new dataset with the following query and use the parameter.


SELECT DISTINCT ParamValue from (

SELECT 'ABC' AS Attri1,'Yes' AS ParamValue

UNION ALL

SELECT 'PQR' AS Attri1,'Yes' AS ParamValue

UNION ALL

SELECT 'XYZ' AS Attri1,'Yes' AS ParamValue

UNION ALL

SELECT 'ABC' AS Attri1,'No' AS ParamValue

UNION ALL


SELECT 'PQR' AS Attri1,'No' AS ParamValue


) X




Regards, RSingh



No comments:

Post a Comment