Clean up of the rational insight data warehouse ...
6 answers
as far as I know there is no easy way to clean up the data for a specific project from the data warehouse.
This is spread over multiple tables and there are a lot of links and references.
If your data warehouse is new, and you don't have much data in it the easiest solution is to drop the database (or the data warehouse schemas in the case of Oracle) and recreate it.
If this is not possible, you might have to add a filter condition in your reports to exclude the data from your old project.
Best Regards,
Francesco Chiossi
One other option is to update your database manually and change the 'issoftdeleted' flag so that the projects and data for this old repository no longer shows up as active, valid data when you run reports.
It will take more manual work, but if you can't afford to drop and recreate your data warehouse (which most people can't) it's another alternative.
Comments
Thank you Sunil for your answer.
Sorry but I think that my question was not clear.
Last week I plugged RQM to Rational Insight.
In RQM there was onlye one project named "Project_one".
This week I uninstalled RQM and I installed it again : for doing this I cleaned the database of RQM.
In RQM I created a new project named "Project_two".
Then currently in RQM I have only one project named "Project_two".
In Rational Insight I see two projects : "Project_one" and "Project_two".
I want to clean the data in the data warehouse, run the DW jobs for RQM (currently I have no other application) to see only "Project_two" in the reports. Is it possible ?
Regards,
Raphaël
correct, the data warehouse need to be populated both from Insight and from CLM.
You can for example use the Insight setup to first populate the data warehouse and then either the CLM setup or the repotools -createWarehouse command for the CLM part.
Best Regards,
Francesco Chiossi
