Thursday, February 17, 2011

Is TFS 2010 cube scary ? Use VS2008 for reverse engineering !

What is this ?

an electronic printed circuit board like the on below ?

Well no, that's "just" the reverse ingeneering of the TFS Analysis Services Database :

File > New Project > BI Project > Import Analysis Services Database

Once done, you'll have access to the 44 tables and their relations on one side (left), and the list of all available BI dimensions on the right hand side.

You can go deeper and check the details of the cube's structure :

Or with this one window "Dimension Usage" to display on which Dimension you can display a relevant Mesure. For instance, below a relation exist between the Dimension 'Build' the  mesure 'Code Coverage'. As a result, you can answer the question : "what percentage of CodeCoverage do I have for on various Builds ?". You can add other relations BUT this is really dangerous in terms of performance, unless you are an expert in BI, otherwise this is not recommanded at all.

You'll also be able to write your own calculations, if you want more KPI indicators on the health of your projects.

For exemple, you can use the Reports (Reporting Services) or EXCEL within your Team Process Teamplate you query the information, or create your own EXCEL 2007+ reports based on PivotTable :

Data > From Other Sources > enter 'Localhost' or the name of your TFS Server > Choose the database 'Tfs_Analysis' and the Perspective :
For instance, we are going to report on how long and how many errors per Build :
The Sigma icon represents the values that are to be aggregated (= Compile Errors and Build Duration), and the other icon represents the axis on which to report (=Build Name)

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.