Requirement Traceability data in the CLM datawarehouse
Hi,
I have a few requirements in RRC which are linked by user stories in RTC by the Implemented by link. For some reasons they are not coming up in the datawarehouse table - REQUIREMENT_REQUEST_LOOKUP
Is this the right table to look at? or is this information stored somewhere else?
I am running CLM 4.0.2 and uses the in-built data collection jobs which push data into the RIDW database.
Any help would be much appreciated.
Regards,
Naweed
I have a few requirements in RRC which are linked by user stories in RTC by the Implemented by link. For some reasons they are not coming up in the datawarehouse table - REQUIREMENT_REQUEST_LOOKUP
Is this the right table to look at? or is this information stored somewhere else?
I am running CLM 4.0.2 and uses the in-built data collection jobs which push data into the RIDW database.
Any help would be much appreciated.
Regards,
Naweed
3 answers
Hi Naweed,
That is the correct table to be checking for links between RRC requirements and RTC work items. I created an "Implemented By" link between a requirement and a story and both ID's were loaded to the REQUIREMENT_REQUEST_LOOKUP table. I would suggest checking the jts-etl.log for errors during the RRC ETL or create a PMR with support to investigate further if needed.
That is the correct table to be checking for links between RRC requirements and RTC work items. I created an "Implemented By" link between a requirement and a story and both ID's were loaded to the REQUIREMENT_REQUEST_LOOKUP table. I would suggest checking the jts-etl.log for errors during the RRC ETL or create a PMR with support to investigate further if needed.
Hi Naweed,
That is indeed the table.
Toni
That is indeed the table.
I just added a linked pair, re-ran the ETLs, and one new row shows up. But I cannot relate the Requirement ID or Request ID in the database table with any Web ID in CLM.
Toni