CODEWITHSUNDEEP
reporting-servicesmdx
Anjali
Anjali

Reputation: 1

Passing MultiValue Parameter in MDX

How to pass MultiSelect parameter from SSRS to MDX?

I tried as below which is not working as expected:

WHERE ({IIF( STRTOSET(@Name, CONSTRAINED).Count = 1,
STRTOSET(@Name, CONSTRAINED), [Name].currentmember )})

Upvotes: 0

Views: 2252

Answers (1)

ic3
ic3

Reputation: 7680

You can use directly :

WHERE ( STRTOSET(@Name, CONSTRAINED) )

or (not sure about this ) :

WHERE ( IIF( STRTOSET(@Name, CONSTRAINED).Count = 1, 
         STRTOSET(@Name, CONSTRAINED), 
         STRTOMEMBER(@Name, CONSTRAINED) ) )

However SSAS and set slicers are not always good friends. If possible use MDX Subselects instead :

WHERE ( SELECT STRTOSET(@Name, CONSTRAINED) ON 0 FROM .. )

Upvotes: 0

Related Questions