By default the Sprint Burndown report is not displayed on the SharePoint Team Portal site. If you are working in an environment with many teams with dashboards for the various teams in SharePoint it may be beneficial to see separate burndown reports for each team. The following process will help get you up and running.
Let’s first configure the Sprint Burndown report in Reporting Services. Open the Reports site from the SharePoint project portal.
When you hover over the Sprint Burndown report you will see a drop down with some options. Select ‘Manage’ to open the report editor. Then click ‘Parameters’ from the left context menu. The screen below will appear.
Verify that the parameters are configured the same as above. The AreaParam will need to be cleared and not have a default forcing us to pass in the parameter.
Next we will need to go back to our SharePoint project portal and create a new Page Viewer web. See below.
Once the webpart is created you will need to configure it to show the correct data. Let’s start by editing the web part and copying the basic link. Open the link editor as show below.
Copy the following link:
http://[SERVER_NAME]/ReportServer/Pages/ReportViewer.aspx?%2fTfsReports%2f[Collection]%2f[TeamProject]%2fSprint+Burndown&rs:Command=Render&rc%3aToolbar=false&AreaParam=[Work Item].[Area Hierarchy].[Area2].%26[5429294642972802883]%26[-8147901280675407906]
We will need to replace some variables in the link from the target system. Replace:
[SERVER_NAME] with the actual server name
[Collection] with the team project collection name
[TeamProject] with the team project name
The last variable AreaParam will require a lookup for the exact code stored in the Tfs_Analysis database. To retrieve it you will need to open SQL Management Studio and connect to Analysis Services.
From there open the TFS_Analysis database and create a new query. The metadata explorer will be automatically opened. Then expand the work item node as shown below:
What you are looking to do is copy the area path node you are interested in showing for the burndown report. Area1 will contain all the first level area paths and Area2 then second and so on. The area path names that are enclosed in quotes will not contain the child nodes while the area paths that are enclosed will contain all child nodes.
Right click on the node and select ‘Copy’. Then paste the string into notepad for editing. It should look something like this:
[Work Item].[Area Hierarchy].[Area1].&[-7595641220719932850]&[-8869689072810421650]
Now replace both ampersands with: %26
So that it looks like this:
[Work Item].[Area Hierarchy].[Area1].%26[-7595641220719932850]%26[-8869689072810421650]
Finally, replace the AreaPath parameter with our newly constructed string above and test the link. The result should be like something below and will only contain the data contained in the provided area path.
Simply repeat the process for each team's SharePoint home page.
Enjoy!
