The Ramblings of Two Microsoft .NET Developers, TFS, and Visual Studio ALM Guys --- "Yes, we are both named Ed."

eScrum - New Scrum TFS Process Template from Microsoft

There's a new Scrum process template and it looks like Microsoft has developed it this time.  You can pick it up here:


eScrum is a Web-based, end-to-end project management tool for Scrum built on the Microsoft Visual Studio Team Foundation Server platform. It provides multiple ways to interact with your Scrum project: eScrum Web-based UI, Team Explorer, and Excel or Project, via Team Foundation Office Integration. In addition, it provides a single place for all Scrum artifacts such as product backlog, sprint backlog, task management, retrospective, and reports with built-in context sensitive help.

We'll have to evaluate it and see where it ranks among the other Scrum process templates.  For now, check out some of the other ones:  (Did I miss any?)

Update:  HOLY CRAP! There is a ton of post-installation steps that you have to take and other items that you have to download.  If you don't happen to have the specific version of the ASP.NET AJAX Control Toolkit that eScrum requires, then you are going to have to do a binding redirect.  If you download it from the ASP.NET AJAX Website, it is a later version.  See the Readme after you install. This setup and install experience is probably one of the worst I have ever done!  Even rivaling the TFS Beta 3 to Beta 3 Refresh upgrade!  That's saying a lot.

Wag of the Finger

Now I'm just having problems with the reports after I've rebuilt the TFS Warehouse five time!  This process template undoubtedly deserves a Colbert Wag of the Finger.


Ed B.

Posted in TFS

Monday, June 18, 2007 4:25:56 PM (Pacific Daylight Time, UTC-07:00)
It is a great tool. What more can I say?

Tuesday, June 19, 2007 11:51:43 PM (Pacific Daylight Time, UTC-07:00)
Yes, it's very cool.
Tuesday, June 19, 2007 11:56:25 PM (Pacific Daylight Time, UTC-07:00)
Ed, the “Sprint BurnDown” report gets data from two data sources, one is “TFSWarehouse” database from which the report gets the Sprint list, process time and Sprint data; the other is “TFSWarehouse” cube which provides data for Sprint Burn Down chart. From the picture which you posted, you could get Sprint list, so I think for the access to “TFSWarehouse” database is fine, but there is something wrong about the “TFSWarehouse” cube.

Based on the error message, the reason for this issue mostly seems to be the security configuration. You may use Report Manager (http://<Report Server Name>/Reports/Pages/Folder.aspx) to explore the further reason. If you can log on the server and use http://localhost/reports, you can see a clearer exception.

For "TfsOlapReportDS" data source configuration, generally we configure as the following values:

1. Connection Type: Microsoft SQL Server Analysis Services
2. Connection String : Data source=<Database Server Name>; initial catalog=TFSWarehouse
3. "Enable this datasource"
4. Security: Generally choose "Credentials stored securely in the report server". Provide a valid network domain\ alias in the User Name and check "Use as Windows credentials when connecting to the data source" option.
Wednesday, June 20, 2007 6:36:28 AM (Pacific Daylight Time, UTC-07:00)
Hey Billy,

Thanks for suggestions. I'll post in a sec the exact message when I look at it from the server. However, the TfsOlapReportDS shared data source is setup properly because all of the other reports in other team projects work just fine. It's only the reports in the eScrum team project that do not work. The user that we use is the standard DOMAIN\TFSReports and I have double-checked that it wasn't an issue with the account.

Sometimes when you get this error message it means the warehouse needs to be refreshed so I have rebuilt it five times with no luck. :-(

Can you think of anything else it might be? Thanks again!
Thursday, June 21, 2007 2:09:30 AM (Pacific Daylight Time, UTC-07:00)
Hi Ed,

Could you please check the following items for the issue?
1.Check the “TFS Warehouse” error message in Event Log
2.Check if the “TFSWarehouse” cube has data
For this check you can either browse the data via Management Studio or write MDX query like the below clause:
SELECT [Measures].[Current Work Item Count] ON COLUMNS,
[Work Item].[System_WorkItemType].[System_WorkItemType].MEMBERS ON ROWS
FROM [Current Work Item]

If there is an error or get no data, could you please send me an email, and then I may reply your comments more quickly?

Thursday, June 21, 2007 2:13:47 AM (Pacific Daylight Time, UTC-07:00)
BTW,my email is
Thursday, June 21, 2007 12:46:17 PM (Pacific Daylight Time, UTC-07:00)
Thanks Billy! I will e-mail you those details.

For everyone else, I'll post an update with the details in a new post (and update this post to clarify the issues.)
Wednesday, July 11, 2007 11:31:12 AM (Pacific Daylight Time, UTC-07:00)
An updated package of eScrum is released to the download site :

See the forum post for the details of the update:
(will show your gravatar icon)
Home page

Comment (Some html is allowed: a@href@title, b, blockquote@cite, em, i, strike, strong, sub, sup, u) where the @ means "attribute." For example, you can use <a href="" title=""> or <blockquote cite="Scott">.  

[Captcha]Enter the code shown (prevents robots):

Live Comment Preview