Hi, It could be very simple question but couldnt get it out from net,so here it is I have a MDX say WITH MEMBER [Measures].[Rev] AS ([Measures].[Total Rev] ,[Dim Period].[Dim Period].&[201211]) SELECT { [Measures].[Rev] } on 0 , NON EMPTY {([DimLocation].[Loc Hierarchy].Members)} on 1 FROM [Cube_FI] All i want is to pass 201211 from my report parameter, My report parameter name is @Period. Pls guide me through what should i do in MDX editor of SSRS to get 201211 replaced by @period. I am using ssrs 2005 Thanks