# Friday, June 15, 2007
« Shuttle Launch at Cape Canaveral | Main | Updated Quiescing GDR Fix Released »
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:  http://www.microsoft.com/downloads/details.aspx?FamilyID=55a4bde6-10a7-4c41-9938-f388c1ed15e9&displaylang=en

Overview

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.

image

Ed B.

TFS
posted on Friday, June 15, 2007 9:49:38 AM (Eastern Daylight Time, UTC-04:00)  #    Comments [8] Trackback
Related posts:
Connecting to TFS from Microsoft Office Outlook
Proposed New Visual Studio ALM Stack Exchange Site
Microsoft’s Islands in the Stream
Lab Management Released and Included with MSDN Subscriptions
Milestone: Microsoft Developer Division and TFS 2010 Build
Recursively Finding Files in TFS Build 2010
Monday, June 18, 2007 7:25:56 PM (Eastern Daylight Time, UTC-04:00)
It is a great tool. What more can I say?

Sam Abolrous
Wednesday, June 20, 2007 2:51:43 AM (Eastern Daylight Time, UTC-04:00)
Yes, it's very cool.
debe
Wednesday, June 20, 2007 2:56:25 AM (Eastern Daylight Time, UTC-04: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.
Billy
Wednesday, June 20, 2007 9:36:28 AM (Eastern Daylight Time, UTC-04: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!
Ed Blankenship
Thursday, June 21, 2007 5:09:30 AM (Eastern Daylight Time, UTC-04: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?

Thanks.
Billy
Thursday, June 21, 2007 5:13:47 AM (Eastern Daylight Time, UTC-04:00)
BTW,my email is v-welu@microsoft.com.
Billy
Thursday, June 21, 2007 3:46:17 PM (Eastern Daylight Time, UTC-04: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.)
Ed Blankenship
Wednesday, July 11, 2007 2:31:12 PM (Eastern Daylight Time, UTC-04:00)
An updated package of eScrum is released to the download site : http://www.microsoft.com/downloads/details.aspx?FamilyID=55a4bde6-10a7-4c41-9938-f388c1ed15e9&displaylang=en

See the forum post for the details of the update:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1848044&SiteID=1
Hamsa
OpenID
Please login with either your OpenID above, or your details below.
Name
E-mail
(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">.  

Enter the code shown (prevents robots):
Live Comment Preview

Page rendered at Thursday, September 02, 2010 6:08:35 PM (Eastern Daylight Time, UTC-04:00)