I'm using SSRS 2005 to report on an SSAS cube that contains a Procedure dimension. I don't need to use members of this dimension in my report, but rather need to select records (patients) where their chart has one or more of the codes.
I've researched this today and cannot locate the best approach. Thus far, I've attempted to create an MDX query parameter as part of my dataset. However, I don't know whether this is the correct approach, and how to structure the syntax so that
only records with one or more procedures are included in the report? If so, what is the proper MDX syntax for setting my Procedure code equal to the query parameter?
View Complete Post