Project Server 2007: My filters don’t work in my Data Analysis views

This came out of a recent Project Server support case where a customer was trying to show the capacity of resources by department in a Data Analysis view, but found that the filter for the resources department (a resource level field) wasn’t working as expected.  If capacity wasn’t shown then the department filter was good…


Project Server 2007: Walkthrough Videos Now Available on TechNet – Installation and OLAP Configuration

Mike Plumley from our UA team has done a great job in producing some walkthrough screencasts of a Project Server 2007 farm installation and also configuration of OLAP.  These follow TechNet articles but show you all the steps involved.  They are available for download as wmv files.  Installing Project Server 2007  (four parts) Using SQL…


Project Server 2007: Can’t find your WSS data in the OLAP cube?

This was a recent support issue with great work from Kate and Shazeb in getting to the resolution.  Getting either of them to take credit was a harder job – so they get to share. The scenario is – you create a project plan, publish and create a workspace, then go to that workspace and…


Project Server 2007: Podcast – Talkthrough of OLAP Cube Building

This podcast is a talkthrough of the process of building a cube.  I forgot to mention firewalls which can also block access to SQL/Analysis Services – so see the TechNet artilces for details.  For other blog postings on this topic go to http://blogs.msdn.com/brismith/archive/tags/Analysis+Services/default.aspx.  


Good news for SQL Server 2008 users – SQL Server 2005 SP3 is out!

That may seem like a strange title, but for Project Server 2007 users of the Analysis Services features this is good news indeed!  Along with the release of SP3 (see Christophe’s blog for more details) is the release of the latest Feature pack for SQL Server 2005.  This includes the update to Management Object Collection…


Project Server 2007: TechNet Document now live for using SQL Server 2008

****Update**** – The December 2008 release of the Feature pack for SQL Server 2005 at http://www.microsoft.com/downloads/details.aspx?FamilyID=536FD7D5-013F-49BC-9FC7-77DEDE4BB075&displaylang=en means that loading the Management Objects Collection from this release will avoid the workaround described in the TechNet article.  The writers have done a great job on revising the 2005 document to address 2008 – thanks Efren.  The document is here…


Project Server 2007 and SQL Server 2008 – Error Messages With Data Analysis Cubes(OLAP)

****Update**** – The December 2008 release of the Feature pack for SQL Server 2005 at http://www.microsoft.com/downloads/details.aspx?FamilyID=536FD7D5-013F-49BC-9FC7-77DEDE4BB075&displaylang=en means that loading the Management Objects Collection from this release will resolve the problems outlined below.  *** Update *** There is now an official document that says some of this and more – See my latest blog for details – http://blogs.msdn.com/brismith/archive/2008/11/21/project-server-2007-technet-document-now-live-for-using-sql-server-2008.aspx…