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.
SELECT
[Measures].[Revenue] ON COLUMNS
,NON EMPTY CrossJoin
(
{[ForecastProductItems].[ProductItemNameLong].Children}
,{
StrToMember(@FromDate):StrToMember(@ToDate)
}
) ON ROWS
FROM [Cube]
WHERE
(
[ForecastProductItems].[Active].&[True]
)