I am new to MDX and struggling to come up with a query that works. I have a SSRS report that filters by week. I need to write a query that will run for last week as default.
The query i have cooked up is:
WITH MEMBER Measures.Lastweek as
[Time Dimension].[Report Week].currentmember.lag(1)
Select Measures.lastweek on 0,
[Time Dimension].[Report Week] on 1
This returns a null value.
I have searched and searched the internet for the answer but i have found nothing. I would really appreciate some help.
View Complete Post