It's all about the answers!

Ask a question

Generate RRDI Report showing requirements linked to TCER


Ramakrishna Vittal (123) | asked Mar 25 '13, 9:49 p.m.
 Hi,

I want to get the a report out of RRDI with the following columns and I couldn't find a way to get this info.

Want a table with the following 4 columns:

Requirement ID, Requirement Description, TCER ID, TCER Description.

Can you please help?

Thanks,
Rama

2 answers



permanent link
Jun Wang (6077) | answered Mar 29 '13, 3:36 a.m.
 Hi, are you using RQM to track testing? In RQM, it does not support requirement associated with TCER directly but
the test case of TCER. RQM OOTB ETL does not build such relationship either.

You may get the test case of TCER and the requirement from the test case.


 

permanent link
Sudhakar Frederick (80113631) | answered Apr 02 '13, 5:05 a.m.
JAZZ DEVELOPER
 Hi Ramakrishna
There is an out of the box sample report that ships with RRDI that you may be able to reuse, taking data from RQM and RRC. Take a look at the "Requirements Execution Results" report in the Public Folders > Sample Report Definitions > QM > Data Warehouse Reports > Requirements folder. Here is a screenshot of one of the lists in the report template:




Comments
Sudhakar Frederick commented Apr 02 '13, 5:34 a.m.
JAZZ DEVELOPER

 Actually here's a query that will give you what you want, just put the columns you need in a list:

[Business View].[Test Plan].[Test Plan ID]
[Business View].[Test Plan].[Name]
[Business View].[Test Plan].[Project Name]
[Business View].[Test Script Related Execution Results].[Name]
[Business View].[Test Plan Related Test Cases].[Name]
[Business View].[Test Plan Related Test Cases].[Reference ID]
[Business View].[Test Case Related Requirements].[Name]
[Business View].[Test Case Related Requirements].[Reference ID]
[Business View].[Test Case Related Test Scripts].[Test Script ID]
[Business View].[Test Case Related Test Scripts].[Name]
[Business View].[Test Case Related Test Scripts].[Reference ID]
[Business View].[Test Script Related Execution Results].[Execution Result ID]
[Business View].[Test Script Related Execution Results].[Reference ID]

Your answer


Register or 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.