This content has been marked as final. Show 1 reply
I suspect you must have solved this problem already as this thread is old.
For passing parameter, function parameter is right. I think, you must facing issue in executing MDX with where condition. right?
for this kind of condition I would use filter functionality of MDX.
filter(<your cross join>,[Measures].[name] > parameter(<parameter Name>,<type>)
Note: Have seen slow behavior sometime while using filter
SELECT [Measures].[Internet Sales Amount] ON 0, FILTER( [Date].[Date].[Date].MEMBERS , [Measures].[Internet Sales Amount]>10000) ON 1 FROM [Adventure Works]
Edited by: Sumant on Feb 6, 2012 1:46 AM