none
Project Portal, MSP_Portfolio_Analyzer, date dimension faulty week number RRS feed

  • Question

  • Hi,

    I am working on a MDX query on the MSP_Portfolio_Analyzer cube of Project and I have problem that the date dimension contain wrong week number. For instance if I browse the dimension to 2013, quarter 3, month September it says day 1 is on Week 36. When I use datepart function to return week number for 2013-09-01 I receive week 35 which is supposed to be correct.

    The format on one date from dimension is:
    [Time].[Time].[Year].&[2013].&[3].&[9].&[36].&[2013-09-01T00:00:00]

    The MDX query I am building is going to show forcast for capacity and worked hours, but I have problem when the week number is off compared with week number retrieved from now(). Any suggestion on how to solve this?

    [Time].[Time].[Year].&[2013].&[3].&[9].&[36].&[2013-09-01T00:00:00]

    Tuesday, December 17, 2013 8:28 AM

Answers

All replies