Parameter Driven MDX Query in RS Report

[SQLBI]

Hi,

I have the following MDX query which drives my latest RS report.

SELECT {[Measures].[Value], [Measures].[WDR], [Measures].[SDR]} ON COLUMNS, NON EMPTY
	{[Supplier].[Product].Members} ON ROWS
	FROM [Margin]
	WHERE [Practice].[Practice].[b][101 - Eccleshill][/b]

However, i want to include a report parameter in the WHERE clause, replacing '101 - Eccleshill' with my parameter, '@Practice', but i can't seem to make it work.

Anyone had this before?

Thanks in advance.


Cheers,
Leigh

"Give a man a fish and he can feed himself for a day..."
Give him the means to catch his own fish and he can really annoy his girlfriend by spending all his spare time fishing!

Join the PAC -

http://www.pacgb.co.uk/