TFS Excel Reports Date Filtering Resolved

Back in September of last year I blogged about an issue I was facing with the task burndown excel report and workbooks that ship with TFS. http://thebasilet.blogspot.com/2010/09/tfs-2010-task-burndown-excel-report-not.html

Brian Harry & Aaron Bjork from Microsoft were very helpful in lending their help to troubleshoot this issue. However, until last week we were ready to give up hope. That is until I stumbled upon the solution thanks, to some comments Aaron made.

Here's the deal, the excel filtering issue I was observing from TFS is actually a bug in Sql Server 2008R2 Analysis Services and is described here
http://support.microsoft.com/kb/982850/


It can be resolved by applying one of the Cumulative Updates on Sqlserver2008r2.
http://support.microsoft.com/kb/981356