Reporting Services On AS2005 Cube

Hi all,



I'm trying to create a RS report that will use an AS2005 cube as a datasource. I did try to use the query wizard from reporting services to build the mdx statement but I'm having a hard time with it... How could I use the following MDX statement in a reporting services report?? Do you have to use the query builder?






Code Snippet



WITH SET [Last 5 Months] AS

{TAIL( NONEMPTY( {[Date].[Calendar].[Month].MEMBERS}, {[Measures].[Internet Sales Amount]} ) ,1).ITEM(0).LAG(1),

TAIL( NONEMPTY( {[Date].[Calendar].[Month].MEMBERS}, {[Measures].[Internet Sales Amount]} ) ,1).ITEM(0).LAG(2),

TAIL( NONEMPTY( {[Date].[Calendar].[Month].MEMBERS}, {[Measures].[Internet Sales Amount]} ) ,1).ITEM(0).LAG(3),

TAIL( NONEMPTY( {[Date].[Calendar].[Month].MEMBERS}, {[Measures].[Internet Sales Amount]} ) ,1).ITEM(0).LAG(4),

TAIL( NONEMPTY( {[Date].[Calendar].[Month].MEMBERS}, {[Measures].[Internet Sales Amount]} ) ,1).ITEM(0).LAG(5)}



MEMBER [Date].[Calendar].[AVG 5 months] AS

AVG([Last 5 Months])

MEMBER [Date].[Calendar].[Last Mth Var.] AS

(TAIL( NONEMPTY( {[Date].[Calendar].[Month].MEMBERS}, {[Measures].[Internet Sales Amount]} ) ,1).ITEM(0).LAG(1) - AVG([Last 5 Months]))

MEMBER [Date].[Calendar].[YTD] AS

AGGREGATE(YTD(TAIL( NONEMPTY( {[Date].[Calendar].[Month].MEMBERS}, {[Measures].[Internet Sales Amount]} ) ,1).ITEM(0).LAG(1)))



SELECT

{[Last 5 Months],[AVG 5 Months],[Last Mth Var.],[YTD]} ON COLUMNS,

NONEMPTY([Product].[Category].Members) ON ROWS

FROM [Adventure Works]

WHERE [Measures].[Internet Sales Amount]



It's probably very simple to acheive but for some reason I can't get this to work properly...





I did a lot of RS against relational DB but reporting out of a cube is new to me.



TIA,

Eric