Just checked the links and they are all now live – so updated my list. One clarification on a the specific KBs and downloads for Project Server and the SharePoint/Microsoft Office SharePoint Servers. The Office Server hotfix I list is the complete package that includes Project Server 2007 April CU too. This is KB 968851 and is called SharePoint Server 2007 cumulative update package (MOSS server package): April 30, 2009. There is another hotfix that I know Christophe and Scott Wagner list in their articles – and this is KB 968859 - Microsoft Office SharePoint Server 2007 hotfix package (Coreserver.msp): April 30, 2009. This one does not contain the Project Server fixes – so very useful if you already loaded the Project Server CU before the combined one was available.
For those who couldn’t make the webcast last month Christophe has now posted details of the recording and other SP2 resources. Christophe and Adrian presented and answered questions covering Project 2007 Service Pack 2 (SP2) as well as the Project 2007 April Cumulative Updates – and future planning guidelines for Project Server 2010.
I don’t usually do too many of the me-too type blog postings unless the technology is Project related, like SQL and SharePoint, but I’ve been so impressed with Windows 7 both at work and at home that I am more than happy to share with you this new material from Microsoft Learning!
What’s New in Windows 7 for Consumers (1 Hour)
What’s New in Windows 7 for IT Professionals (2 Hours)
What’s New in Windows 7 for Information Workers (2 Hours)
And if you are interested in more Windows 7 training and skills development information, the Windows 7 Learning Portal is now live as well!
This site is currently showcasing great readiness content, including 7 Silverlight Learning Snacks, free sample chapters from upcoming MS Press Books, Learning Plans, links to clinics/HOLs and more. This page can be found here - http://www.microsoft.com/learning/windows-7/default.mspx
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 – but as soon as capacity was added then all resources were shown regardless of the departmental filter. I thought the cause and resolution was worth sharing. Thanks Chris Bulson for your great work on resolving this one.
When using Data Analysis views against the SQL Server Analysis Services OLAP (cube) database you are often getting data about multiple entities each having their own grouping. This is similar in some ways to querying a SQL Server databases – if you get the joins wrong between tables you can either get nothing or too much data!
In the example above you are showing an assignment level field and wanting to filter by a resource level field – and there is no default way to join these. The answer can be found in the cube configuration section of Server Settings, where you can ensure you add any task or resource custom fields you want to use to both the task/resource level and also the assignment level. You would then need to rebuild the cube and would then be able to show capacity by department – as per the example above.
News from TechEd 2009 this morning on the requirements for the next release of SharePoint – which will be called SharePoint Server 2010. As Project Server 2010 will be built on the same platform then expect similar requirements. In brief these are:
The 64-bit SQL requirement is new news, and I feel this makes a lot of sense. We have seen customer’s adopting 64-bit for SQL at a fast pace, and have seen great benefits for Project Server 2007 – so to only release 64-bit Office Servers and to support 32-bit database back-end would not have made much sense.
Likewise dropping support for IE 6 (which end it’s support lifecycle anyway in July 2010) should not cause too many concerns. If my blog readers are any indication the IE 8 users have already overtaken IE 6 – which accounts for less than 1 in 5 browsers to my blog. This only applies to authoring content – and it will still be possibly to target a SharePoint published site to IE 6 for viewing. I do appreciate though that some corporations still have IE 6 as the norm – so time to start planning that move!
Remember that in 2007 Project Server had a tighter requirement on browsers than SharePoint – and blocked non-IE browsers from the PWA sites (but not workspaces). I haven’t seen any announcement on any changes here.