November 7, 2003 at 9:44 am
I'm comparing this year to last year mtd, the issue being that the current month is not complete, so I'm trying to make my comparisons equal. Therefore, how do I compare the first 5 days of Nov 03 and compare to the first 5 days of Nov 2 using MDX?? My current syntax to obtain last years number looks like this, but it does not provide for a similar time period. I've looked at OpeningPeriod, ParallelPeriod, etc, but not getting anywhere....
SUM(MTD(ParallelPeriod([Time].[DSR Year], 1)), [Measures].[Margin])
Ardley Tschetter
Ardley Tschetter
November 10, 2003 at 8:00 am
This was removed by the editor as SPAM
November 11, 2003 at 10:22 am
What is your current time member? For this to work correctly you will need to be referring to the day not the month.
For instance:
current date = 11/5/03 = [Time].currentmember
ParallelPeriod([Time].[Year], 1) = 11/5/02
MTD(ParallelPeriod([Time].[Year],1) should return the set - 11/1/02-11/5/02
The sum of this set should return the value you are looking for. The only way this will not work is if your Time.currentmember is not the last day of your set. In that case you may need to explicitly state the Time member you are working with.
Hope that helps.
Steve Hughes
Magenic Technologies
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply