Post reply

ParallelPeriod more granular

  • November 7, 2003 at 9:44 am

    #106475

    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

    #481609

    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