Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Reporting   (RSS)
Saturday, May 16, 2009 4:15 PM

Team Foundation Server 2010 - Relational Warehouse and Cube Schema Changes

Team Foundation Server 2010 is a BIG release for us by all counts. We have made conceptual changes; Brian introduced some of the key concepts in TFS 2010 that includes the concept of Team Project Collections (TPCs). These changes required a lot of infrastructure
Posted by sunder | 5 Comments
Wednesday, April 29, 2009 8:06 PM

Previous State and State Change Count

Today I am going to look at two interesting fields in the Warehouse related to Work Items – Previous State, and State Change Count. The Previous State field stores the state a Work Item was in before it entered its current state. This field is in the
Posted by nericson | 2 Comments
Friday, March 20, 2009 11:56 PM

TFS Warehouse Work Item Tracking Compensating Records

Compensating Records What are compensating records? First a little background. Whenever a work item is updated a new revision is created. These revisions are moved over to the Warehouse and stored in the various Work Item Dimension and Fact tables. Each
Posted by nericson | 2 Comments
Wednesday, May 14, 2008 12:45 PM

How Microsoft/DevDiv uses TFS - Chapter 6 (Addendum)

In my previous post , some people asked how we went about creating the report I talked about. I asked the fellow who created this report internally. Here was his response, which I'm passing on to you. (Thanks Doug!) NOTE: I've also attached the .RDL file
Posted by Gregg Boer | 3 Comments
Attachment(s): FC High Level Summary of Work.rdl
Friday, February 22, 2008 8:38 PM

Demo - tutorial: Building a TFS report using Report Designer

I gave a talk to an internal team sometime last year on building TFS reports. The talk was recorded and I rediscovered that video a few days ago. I did a couple of report-building demos during the talk. Here's one of them:       Ameya Bhatawdekar
Posted by Ameya | 3 Comments
Filed under: ,
Tuesday, February 12, 2008 12:50 AM

As of Today TFS Cube Report in Excel

This walk through shows you how to get started using Excel to build a TFS report displaying Cube data relative to today. When you build a report using an Excel Pivot Table often you want to filter that data by a date relative to today. For example you
Posted by nericson | 2 Comments
Filed under: ,
Thursday, February 07, 2008 12:34 AM

FAQ #6: How do I change the frequency that the reporting warehouse updates?

This tip comes from Markus Hain : The default update frequency is 3600 seconds (1 hour), below are the steps to change the time. 1. Log on to the application tier of Team Foundation Server. 2. Start Internet Explorer. 3. In the Internet Explorer Address
Posted by sbhatia | 1 Comments
Filed under: ,
Sunday, February 03, 2008 3:37 AM

Radius 90 v2 from 90 degree software has Analysis Services Support!

Last month, 90 degree software released their Radius 90 v2. The Radius tools are all about making report design and analysis simple. Radius 90 has an easy-to-use Fluent UI style made popular by Office. One of the key additions was the support of Analysis
Posted by sbhatia | 2 Comments
Filed under: ,
Wednesday, September 05, 2007 8:19 AM

New content on creating custom reports

There is new content on MSDN on building custom reports. Allen Clark has more details about it on his blog post: http://blogs.msdn.com/vstsue/archive/2007/08/29/new-content-available-on-creating-custom-reports.aspx
Posted by Ameya | 0 Comments
Filed under:
Monday, April 30, 2007 6:25 PM

Understanding the TFS Cube

The initial learning curve for the TFS Cube is pretty steep. It is quite overwhelming to figure out the relationships between the large number of dimensions and measure groups in the TFS cube at first. In this blog entry I will explain some of the most
Posted by Jimmy Li | 34 Comments
Filed under:
Monday, March 26, 2007 5:57 PM

TFS Report developer resources

Mauli, a core reporting team member, has compiled a great reference list of articles, reference documentation, tutorials and blogs for report developers. From: Mauli Shah Hi all, There have been a lot of questions about references for making reports.
Posted by Ameya | 5 Comments
Filed under:
Wednesday, February 28, 2007 2:04 PM

Team Foundation Server Reporting and Visio 2007

Visio 2007 has some very cool new reporting features. I'm very excited about the the PivotDiagram features in particular. PivotDigrams can be used to slice and dice data just like Pivot Tables in Excel. Here's an example of a Visio report that shows the
Posted by Ameya | 5 Comments
Filed under:
Tuesday, January 23, 2007 2:51 PM

A cool report authoring tool

In V1, the primary report authoring options are 1/ write SQL Server Reporting Services (SSRS) reports using Visual Studio Report Designer (part of the Business Intelligence Studio – or BIDS) 2/use Excel to connect to the cubes and build reports. Users
Posted by Ameya | 2 Comments
Filed under:
Thursday, January 18, 2007 11:24 AM

Tell us what you think about TFS Reporting

Reporting is a very powerful feature in TFS. It has a lot of capabilities and can provide some very deep and meaningful insights across the development lifecycle. But, some of our customers aren't using the reporting system to its fullest potential. The
Posted by Ameya | 1 Comments
Filed under:
 
Page view tracker