I am using the adventureworks 2008dw and cube, What I am trying to accomplish is getting the sales amount for the last period also, example I want sales for Jan 2007 and Jan 2006 and so on for all the month/year.
What am I doing wrong? I have not worked much with mdx and can use your help. As of now the results I get for the ParPeriodSales member is error.
with
member [Measures].[ParPeriodSales] as
(
ParallelPeriod([Date].[Fiscal],1,[Date].[Fiscal].[Month].CurrentMember)
,[Measures].[Sales Amount]
)
select {[Measures].[ParPeriodSales],[Measures].[Sales Amount] }on 0,
[Date].[Fiscal].[Month] on 1
from [Adventure Works]