What are the new tables/columns were added to the RIDW in support of CLM 3.0.1.2?
Our organization recently installed CLM 3.0.1.2, and the new .XDC files and the new Cognos Data Manager packages have all been installed and configured for Insight.
In the process of validating our work and promoting the new reporting artifacts to our users, I would like to know what new tables have been added to RIDW, and what new columns have been added to the existing tables, specifically for:
- RQM
- RRC
I don't have access to the MS SQL Server database scripts that were executed, and the log files don't show exactly what actions were performed.
Can anyone assist or direct me to something that contains this level of information, as I did not see anything specific in the CLM release notes?
We have CLM 4.0 on our horizon, and I imagine that I'll have similar questions at that time.
Thank you for your assistance,
James Roach
2 answers
Do you have access to the installation folder where CLM is installed? If so, you can look at the file called calm_301_to_3011.sql in C:\ibm\jazzteamserver\datawarehouse\mssql\migration which outlines the DW changes between 3.0.1 and 3.0.1.2. You'll notice that only new triggers/indexes have been added/removed.
As for 4.0, maybe someone on the reporting team can comment on changes between the 3.x and 4.0 DW's, because I don't see these files provided in the installation folder (perhaps the updates are made via pure Java now).
As for 4.0, maybe someone on the reporting team can comment on changes between the 3.x and 4.0 DW's, because I don't see these files provided in the installation folder (perhaps the updates are made via pure Java now).
Comments
James Roach
Jul 06 '12, 3:56 p.m.We migrated from CLM 3.0.1 to 3.0.1.2. Our version of Insight is 1.1.