Workitem Delete and the data warehouse

I would not assume that the datawarehouse will loose the historical data it had collected. I would assume the work items deleted would just not show up in new data that is collected. If you deleted several work items, I would assume to see a drop in the total count in the trend data after the next run of the data collection jobs.

If you delete build results that have failed, the historical data should also stay in the data warehouse. Just because something is not there any longer should not impact the history. At least this would be what I would expect.

I would not assume that the datawarehouse will loose the historical data it had collected. I would assume the work items deleted would just not show up in new data that is collected. If you deleted several work items, I would assume to see a drop in the total count in the trend data after the next run of the data collection jobs.

If you delete build results that have failed, the historical data should also stay in the data warehouse. Just because something is not there any longer should not impact the history. At least this would be what I would expect.

Yes, I agree that the data would be deleted out of the ODS, but not the DW. However it seems like we'd end up with some orphan records in the warehouse that show up in the reports as active (issoftdeleted = 0) even though they're not valid any more, which seems like a problem.

In this case, I would not hesitate to create a PMR or a work item. If they are really deleted, I would expect them to be deleted and vanish as current data, but there might be design reasons for this, I would not be aware of.