SSRS 2005 Cube Reporting Parameter Operator

Hi All,

I'm using SSRS 2005 to report cases that meet specific criteria from my SSAS cube.  The criteria includes discharge fiscal year, and procedure code in a list of numerous codes not in a range.  I tried using the Equals operator with procedure code and selected multiple codes.  However, my result does not tie back to source data.  Should the In operator be used instead of Equals? 

Thanks,

Sid

If you are using multi value parameters you will need to use the in statement. If you are using a stored procedure then check out this blog.

http://www.bidn.com/blogs/MikeDavis/ssis/360/multi-value-parameters-from-stored-procedures-in-ssrs

MikeDavis said:

If you are using multi value parameters you will need to use the in statement.

Hi Mike,

I'm not defining any report parameters.  Rather, I'm trying to select multiple values for my ICD9 Procs Dimension under the Data tab of the Report.  When I try to use Equals and check each value, my results don't tie back to my source system, or to the TSQL query written against the same database on which the cube is derived. 

If I change the Operator to In on my ICD9Procs dimension, the Filter Expression just has TopIPProcs as an available selection.  Do I need to define another selection within the cube itself to pick just the procedure codes for my new report?  If so, where in the Cube is that created?

Thanks,

Sid

I would go back to the cube a create a named set and filter on this in the MDX query.