I solved it in the end!
I did this with my member assignment
WITH
MEMBER [CompareDates]
AS
"{
[Date].[Calendar Date].[Date].&[20050701]
,[Date].[Calendar Date].[Date].&[20050702]
,[Date].[Calendar Date].[Date].&[20050703]
,[Date].[Calendar Date].[Date].&[20050704]
}"
and then with that I can do
STRTOSET([CompareDates])
This solved my issue and I was able to view the figures for any range of comparative dates that the user chose
In SSRS I have 2 date ranges
the user selects the dates they want
Using those dates a bit of T-SQL finds the range of comparative dates I need from those 2 date ranges
I have this set as a mult value parameter.
I the pass that multi value parameter to a sting
Then it is that string I pass through to my MDX doing a STRTOSET
I see comparative figures against my normal date figures and it works really well
Thanks for responding