Best Way To Enable Users To Choose Between WTD/MTD/QTD/YTD At Run Time (MDX)

Hi there - I have a longish bit of MDX which enable some MTD reporting. I'd like to power up the report so that users can select to report by WTD, QTD, YTD by clicking hyperlinks / buttons / whatever [I'm quite new to reporting services - not quite sure what's possible.]



I could create 4 separate reports with 4 separate datasets, or one report with 4 datasets, or is there some reasonable way I can tweak the MDX for a dataset on the fly, e.g. "search and replace, find MTD replace with QTD" &c &c.



Cheers,



JG







WITH

MEMBER [MEASURES].[WT TO MTD]

AS SUM(MTD([Time].[Year - Quarter - Month - Date].CURRENTMEMBER)

,[Measures].[TURNOVER])

MEMBER [MEASURES].[WT TO MTD PrEq]

AS SUM(MTD(parallelperiod([Time].[Year - Quarter - Month - Date].[Month] ,1

,[Time].[Year - Quarter - Month - Date].CURRENTMEMBER))

,[Measures].[TURNOVER])

MEMBER [MEASURES].[WT TO MTD Vs PrEq]

AS IIF([MEASURES].[WT TO MTD PrEq]=0, null

,([MEASURES].[WT TO MTD] / [MEASURES].[WT TO MTD PrEq])-1), format='0.00%'

MEMBER [MEASURES].[WT TO MTD Rank]

AS RANK([SECTOR3].[SECTOR3 ID].CurrentMember

,[SECTOR3].[SECTOR3 ID].[SECTOR3 ID].ALLMEMBERS,

[Measures].[WT TO MTD])

MEMBER [MEASURES].[WT TO MTD PrEq Rank]

AS RANK([SECTOR3].[SECTOR3 ID].CurrentMember

,[SECTOR3].[SECTOR3 ID].[SECTOR3 ID].ALLMEMBERS,

[Measures].[WT TO MTD PrEq])

MEMBER [MEASURES].[WT TO MTD Vs PrEq Rank]

AS RANK([SECTOR3].[SECTOR3 ID].CurrentMember

,[SECTOR3].[SECTOR3 ID].[SECTOR3 ID].ALLMEMBERS,

[Measures].[WT TO MTD Vs PrEq])

SELECT NON EMPTY { [Measures].[WT TO MTD]

, [Measures].[WT TO MTD PrEq]

, [MEASURES].[WT TO MTD Vs PrEq]

, [MEASURES].[WT TO MTD Rank]

, [Measures].[WT TO MTD PrEq Rank]

, [MEASURES].[WT TO MTD Vs PrEq Rank]

} ON COLUMNS,

NON EMPTY { order([SECTOR3].[SECTOR3 ID].[SECTOR3 ID].ALLMEMBERS,[MEASURES].[WT TO MTD Vs PrEq], bdesc) } ON ROWS

FROM [WmCube4]

where [TIME].[Date].&[2007-06-04T00:00:00]