How can I pass Multiple product name as a parameter to this MDX based on selection in SSRS reports. I want to replace [ProductItemNameLong] from this MDX and use parameter variable.
I have another MDX query which returns productname and I am stroing it to @Products as a Parameters.
[Measures].[Revenue] ON COLUMNS
,NON EMPTY CrossJoin
) ON ROWS