WITH MEMBER [Measures].[FutureRevenue] AS
SELECT [Measures].[Sales] ON 0,
[Date].[Hierarchy].[Year] ON 1
How do I get the above script to look back one year regardless of the MemberLevel. Currently, if the CurrentLevel is month, it goes back one month and if the currentlevel is year it goes back one year. I want to go back one year regardless of the member
level. For example, for months it should go back one year and look at the corresponding month.
Thanks in advance.
View Complete Post