Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Common_Snapshot.LINKS table not available from Insight

I need to create an Insight report that shows data from RQM and RTC. Specifically, I need to show the ID, Summary, Due Date, etc of Defects created when running TestScripts in RQM, where a Tested By cross server link is set up between RTC and RQM.
I assume this information is in the COMMON_SNAPSHOT.LINKS we used in BIRT (I might be wrong, never created a report for cross-server links). This table as it appears in BIRT can be seen in this screenshot:

http://img825.imageshack.us/img825/3499/birtlinkstable.jpg

But when accessing RTC data from Insight Metadata Wizard, that table is not available in COMMON_SNAPSHOT, as you can see in the next screenshot:

http://img600.imageshack.us/img600/9312/insightlinkstable.jpg

I'm not sure why that table is not appearing. Even if it were there... is that the right table to use for accessing cross-server links like the ones I need to report on? (RQM ScriptStep related to a Defect stored in RTC using cross-server links like "Tested By").

Any help would be appreciated.

Thank you!

0 votes



One answer

Permanent link
I need to create an Insight report that shows data from RQM and RTC. Specifically, I need to show the ID, Summary, Due Date, etc of Defects created when running TestScripts in RQM, where a Tested By cross server link is set up between RTC and RQM.
I assume this information is in the COMMON_SNAPSHOT.LINKS we used in BIRT (I might be wrong, never created a report for cross-server links). This table as it appears in BIRT can be seen in this screenshot:

http://img825.imageshack.us/img825/3499/birtlinkstable.jpg

But when accessing RTC data from Insight Metadata Wizard, that table is not available in COMMON_SNAPSHOT, as you can see in the next screenshot:

http://img600.imageshack.us/img600/9312/insightlinkstable.jpg

I'm not sure why that table is not appearing. Even if it were there... is that the right table to use for accessing cross-server links like the ones I need to report on? (RQM ScriptStep related to a Defect stored in RTC using cross-server links like "Tested By").

Any help would be appreciated.

Thank you!



Links is actually not a table in the data mart, but a view upon live operational data from the repository. Our BIRT Data Sets allow both types of data access (data mart, and live data). So unfortunately there's nothing you can extract here from our data mart.

james
RTC Reports Team Lead

0 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 10,937

Question asked: Nov 12 '10, 1:08 p.m.

Question was seen: 5,318 times

Last updated: Nov 12 '10, 1:08 p.m.

Confirmation Cancel Confirm