Hi Demetrio,
Let me see if this is your scenario:
1. You created a new field in a Work Item Type but you didn't mark it as reportable.
2. You created a bunch of new work item revisions and added values to that field.
3. You know marked that field as reportable.
4. You continue to created new work item revisions with values in that field.
If that is what you did then you are correct, all the work item revisions that you created in 2 won't have a value for that field in the Warehouse. Work Item revisions created after 3 will have value for the field in the Warehouse. This is because once you marked a field as reportable the adapters won’t go back to see if previous revisions already had a value in that field and update those in the Warehouse. Only new revisions will get the field uploaded into the Warehouse.
What is also true is that if you rebuild the warehouse then all the revisions will be re-uploaded and because the schema change in the warehouse takes place now before any revision is uploaded then all the revisions that have a value in that field will have the value in the Warehouse.
When you say you deleted the Warehouse and re-implemented it, do you mean you ran setupwarehouse. Did you run setupwarehouse with the -rebuild option or with the -o options The -o option will only rebuild the cube but won't force all the data to be re-uploaded to the Warehouse. The -rebuild option will completely delete the Warehouse and the cube and all the data will be re-uploaded by the adapters. This could be very expensive if you have a large amount of data.
If you are not interested in seeing the old values for this field another thing you can do instead of rebuilding the warehouse is just updating all the workitems you are interested in by adding a simple comment. This will create a new revision for them and the new revision in the Warehouse will include the value for the field.
I hope this helps.
Thanks.
Federico
|