DCSIMG
Team System,Reports - Shai Raiten's Blog

Shai Raiten's Blog

It's all about code...

Browse by Tags

All Tags » Team System » Reports (RSS)
Create OLAP Failed – XML parsing failed at line 1, column 0: A document must contain exactly one root element.
Create OLAP Failed – XML parsing failed at line 1, column 0: A document must contain exactly one root element. I’ve visit one of my customers and saw a strange error in the event log: Errors in the metadata manager. An error occurred when instantiating a metadata object from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\TfsWarehouse.0.db\Today.886.dim.xml'. Detailed Message: Create OLAP failed Exception Message: XML parsing failed at line 1, column 0: A document must...
Some Team Foundation Server 2008 Reports give errors with SQL Server 2008
Some Team Foundation Server 2008 Reports give errors with SQL Server 2008 Some reports will generate errors, when no errors occur with the same reports if used against SQL Server 2005. Depending on the specific data available for the report, and parameters selected, you may see errors similar to the following. You may also see some variations of these error messages, or see errors listed under a reports below when viewing other reports. The full error information will appear only if viewing the reports...
Email Reporter: VSTS 2008 Load Test Plug-in
Email Reporter: VSTS 2008 Load Test Plug-in Microsoft’s Visual Studio Team System Test Edition provides a powerful platform to perform high volume load testing. It also provides high end flexibilities to write and utilize external plug-in for extended functionalities. "Email Reporter: VSTS 2008 Load Test Plug-in" enables users to send the load test reports to one or more pre-configured email addresses automatically, once a VSTS Load Test is completed. This open-source load test plug-in...
Announcing TFS Performance Report Pack
Announcing TFS Performance Report Pack Grant Holliday upload TFS Performance Reports that Microsoft use. Quote” We have a responsibility to ensure that the server is performing as expected and to identify any efficiencies that can be made in the server or the tools.  To do this, we have created a number of reports that we use ourselves and make available to our own users. “ The Full Article + Download Execution Time Summary Server Status - Source Control Request Queue Server Status - Top Users...
Failed To Create Maintenance Plan For TFS Backup
Failed To Create Maintenance Plan For TFS Backup After installing TFS 2008 I want to create maintenance plan using SSMS to create a Backup plan How To: Backing Up a Team Foundation Server database . When creating new maintenance plan I got an error. Then I saw that SQL Databases is upgraded to SP2 but not the Client Tools. So Download SQL Server SP2 and make sure to select the right components. After installing SP2 for the Client Tool I was able to create the maintenance plan for backup TFS Databases...
Error While Trying To Create OLAP Cube
Error While Trying To Create OLAP Cube One of my customers failed to get up to date Reports from TFS. Looking in one of the reports I saw that the last time the warehouse was update is Two Month Ago! I tried to process the cube manually and this got nothing, so I checked the event log and I saw couple of errors related to the warehouse. I tried to Rebuild the cube using SetupWarehouse.exe and get another error. An unexpected error occurred: Some or all identity references could not be translated...
How To: Change Estimate/Remaining/Complete Fields Format To Days Instead Of Hours
How To: Change Estimate/Remaining/Complete Field Format To Days Instead Of Hours I receive the following question: How do I change the format for reporting a work: estimate/ remaining/complete - to days instead of hours??? Here is my answer for that question: To download a mapping file Open a Command Prompt window. Open the folder where Visual Studio is installed (for example, drive :\Program Files\Microsoft Visual Studio 9), and in that folder, locate \Common 9.0\IDE. The TFSFieldMapping.exe utility...
Reports Part 1 : Understanding Team System Reports
Reports Part 1 : Understanding Team System Reports I think everyone knows that Team System can show Reports, but not everyone knows that Team System can show Reports on almost EVERYTHING you do inside Team System. Also many people don’t understand the importance of Reporting and how using Team System Reports can help them improve the ALM process. When I demonstrate to customers the Reports ability in Team System I get two different responses: Customer 1: WOW!!!! Customer 2: Why? Here is some questions...
Let’s Report With Team System
Let’s Report With Team System I started to write copule of posts and screencast about Team System Reporting. In those posts and screencast I’ll explaine the significance and probabilitys for using Team System Reports. Here is a glimpse: Understanding the Data Warehouse Architecture Understanding the TFS Cube Creating and Customizing TFS Reports Report Designer Aggregate Report Detailed Report MDX & T-SQL Training and Examples
Exclude File From Code Churn
Exclude File From Code Churn If you want to exclude specific file from the code churn in TFS Reports look in Neno Loje blog. Disadvantages: Comparing binary files in the command line or UI will just result in "Binary files differ" rather than a diff viewer showing the changes. By default, multiple checkouts of binary files are not allowed.
How To: Create TFS Reports Using Excel
How To: Create TFS Reports Using Excel (PivotTable) I have customers that from time to time need new reports for them self not for the all project, I asked them why you need me to create this king of report? The answer is: I don't know how and it's too complicated... My answer: No it's not! In less then 5 min you will be able to create report like the one below that sync directly from TFS. Let's Start Open Excel 2007 click on Data tab and click on From Analysis Services . Enter TFS...