|
|
Engineering Practices – v2.2 Reports
Started by ccolell at 01-23-2009 11:27 . Topic has 1 replies.
  
|
|
Sort Posts:
|
|
|
|
 01-23-2009, 11:27
|
ccolell
Joined on 12-28-2008
Barcelona
Posts 15
|
Deleted build definitions still are shown in build reports !
|
|
|
|
|
Hello,
I have deleted some build definitions from my TFS2008 project, but it seems that still are kept in the datawarehouse. Then, Scrum for Team System Build Reports , have a parameter to show to the user the build definition to filter results and deleted build definition are also shown, which is anoying.
Is there any way to delete build definitions from the datawarehose ?
Or, is there any way to change the query you have in the reports to obtain the build definitions within a project, so it will return the definition names of a project that exist but not the ones that have been deleted from Team System ?
I'm talking about this query:
WITH
SET RealBuildTypes AS
{[Build].[Build Type].[Build Type].Members - [Build].[Build Type].UNKNOWNMEMBER}
MEMBER [Measures].[ParameterCaption] AS
[Build].[Build Type].CURRENTMEMBER.MEMBER_CAPTION
MEMBER [Measures].[ParameterValue] AS
[Build].[Build Type].CURRENTMEMBER.MEMBER_CAPTION
SELECT
{
[Measures].[ParameterCaption],
[Measures].[ParameterValue]
} ON COLUMNS,
{
Filter(RealBuildTypes, [Measures].[Build Details Count])
} ON ROWS
FROM [Team System]
WHERE ( STRTOMEMBER("[Team Project].[Team Project].[" + @Project + "]") )
Best regards,
Carlos.
Carlos Colell Sorinas
|
|
|
|
|
Report
|
|
|
|
|
01-26-2009, 1:59
|
Steve Wright
Joined on 02-05-2008
Egham
Posts 173
|
Re: Deleted build definitions still are shown in build reports !
|
|
|
|
|
|
|
Hi Carlos
Thank you for your post. Unfortunately there is currently no visible method to detect which build types have been deleted. The only way to remove data from the warehouse is as follows:
- Physically delete data from the source system (Team Build, Work Item Tracking, etc..).
- Using the TFS.exe or the TFS power tools.
- Drop and Recreate the Warehouse
- Run the warehouse adapters
- This will happen when warehouse is dropped and recreated.
Please be advised that this will affect all deleted data, and some history from the TFS system could be lost.
Also there is another post where some more information will be available:http://www.scrumforteamsystem.com/cs/forums/3472/ShowPost.aspx. They also have the same problem.
Regards.
Steve Wright
Technical Consultant
EMC Consulting
|
|
|
|
|
Report
|
|
|
|
|
Scrum for Team ... » Version 2.x - T... » Engineering Pra... » Re: Deleted build definitions still are shown in build reports !
|
|
|
|