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:

    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?


    Tuesday, December 17, 2013 8:28 AM


All replies