There are a few of you out there that have asked why the order of the Weeks in the OLAP cube have Week10 before Week6 – this hotfix addresses this ordering/sorting issue and a couple others.

Description of the Office Project Server 2007 hotfix package (Pjsrvapp-x-none.msp, Pjsrvwfe-x-none.msp): October 25, 2011

This article describes the issues that are fixed in the Microsoft Office Project Server 2007 hotfix package that is dated October 25, 2011.

Issues that this hotfix package fixes
  • The resource plan is checked in before you save it in Office Project Server 2007. Additionally, you receive the following error message:

    The resource plan is no longer checked out to you and your changes will not be saved. Contact the Project Server administrator.

  • Assume that you add the time dimension to the Data Analysis view in Project Web Access (PWA). When you expand the time dimension to view the Week level, Week10 is displayed before Week6 in February 2011. 
    Note This issue will occur again in March 2012.
  • When Office Project Server 2007 creates a large volume of shadow table records, performance problems may occur. Additionally, the shadow table records may cause severe database bloating in the draft and published databases.

MSFT article:  http://support.microsoft.com/kb/2596542