Scenario reports are empty / related work items show nothing in TFS Beta 3 refresh

Question

I posted a bug on this: http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=4800f3c5-f9b5-4e62-bc05-a306c96b38de

Has anyone else had this problem / figured out how to get the data warehouse to properly pull the right data?

Answer 1

Just to confirm - just the scenario and related workitem reports are showing blank even though the data is in the warehouse, right?  We've been investigating that issue with a couple other customers and we believe it is in the processing instruction we generate to process the cube - the data should be there.  The dev working on that area has asserted that it's fixed but we are trying to confirm.  We have not been able to repro it on the current RTM builds.

Answer 2

I believe this is the case - what steps would I go through in order to confirm that this specific data is in fact in the warehouse?

I added the line to the web.config from http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=139746&SiteID=1 but this did not solve the issue.

All reports other than Scenario details and Related work items seem to work correctly. Both Scenario details and Related work remain empty.

Answer 3

You may not have seen my reply dated Dec 5 - we still have no workaround to getting the scenario and related work item reports to work.

How can we troubleshoot this?

Answer 4

Have you been through all of the steps in the warehouse troubleshooting guide?

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=154526&SiteID=1 

Answer 5

I have - and it appears that the data processed into the warehouse corectly.

Answer 6

At the top of the other reports that work, there should be two date times - one is the date time the report was rendered and the other should be the last time we successfully processed the warehouse - by successfull I mean we processed all the data into the warehouse and we successfully processed the cube.  Is the second date/time approx. an hour old?

Another thing to try is to manually process - open sql enterprise manager, connect to Analysis Services (drop down in upper left), expand down to the TfsWarehouse DB and right click, Process.  Select OK to process and within a minute or so, it should be fully processed.  Go back to the report, disable caching (in the troubleshooting guide), and then click from the properties tab back to the view tab (not sure why but yesterday I noticed it didn't refresh till I switched tabs.)

One last thing to try - expand down to the Team System cube and select to browse the cube.  The full list of dimensions and attributes should be listed - what's in that list?  (In the troubleshooting guide, I want to add a way to compare what the dynamic should be vs. what it is).

Thanks

Answer 7

It turns out the issue was that we have a CMMI project and the scenario report was inadvertantly included in this project type.

The solution to edit the web.config for the data warehouse full processing solved the related work items report.