I have Team Foundation Server 2010 and SQL Server 2008 SP2 installation and am looking at the out-of-the-box Excel Reports for an Agile project. All of the Excel Reports connect to the TFS OLAP cube successfully and show the correct data for our 2+ years of bugs, work items, tests etc.
Unfortunately the row labels in the PivotTable and Chart (x-axis) are always blank for the Date fields (e.g. "Last 4 weeks") making the chart difficult to interpret. The number of rows look correct, and even the drill down seems to work although that's difficult to judge without labels.
I've looked at the dbo.DimDate table in TFS Warehouse and it does indeed have a row for each day, but all the other columns are NULL (apart from DateSK, DateTime and LastUpdatedDateTime) i.e. YearString, MonthString etc. are all NULL. Is that normal?