Creating traceability documents with RPE and JRS

If you have ever had to generate a document that contains Requirements, the Test Cases that validate them and the related work items you’ve most likely ended up using (at least) 3 different data sources and you’ve had to use Java Script to switch between APIs.

Aside from a complex design, the performance of the report wasn’t that great as RPE had to crawl over all the data sources to fetch the required data.


Using JRS 6.0 to fetch the same data from the Data Warehouse/LQE makes creating such documents much simpler. You can select, filter and sort the data with a JRS report and then use that report in RPE . And as described in How to embed JRS Charts in RPE Documents you can also include the graphical representations of JRS reports.

Using the JRS query as a data source for RPE simplifies the template design and increases the runtime performance.

In many scenarios you will only need a single data source which has a schema that is simple and clean since it contains just the data you need. Add to this the fact that you can filter and sort the data in JRS and the conclusion is that you can focus on the document layout in RPE and leave the data aggregation and selection to JRS.


NOTE: not all the data is available through JRS since not all the data properties are stored in the DataWarehouse. Rich text data and images are among the missing properties, You can obtain them however by making individual calls through the Reportable REST APIs while still taking advantage from JRS providing the structure of the document.

Here is a template that produces the traceability document. I have kept it minimal to increase the dramatic effect.


By contrast an equivalent RPE template using the Reportable REST APIs directly would have spanned across a couple of pages. The snapshot below is the section of an older RPE template that traverses the requirement to test case link. More details are available here


And this gets better as you can add test case results, execution records, child work items and much more.


Author: Dragos Cojocari

Architect for Rational Publishing Engine

3 thoughts on “Creating traceability documents with RPE and JRS”

  1. Hello,

    I hope some one could help me check datasource null before getting values of attribute passed to template elements.
    step by step i did as bellow:
    – create a report get data from data Warehouse ( report contain null data)
    – create a template has a table contain 4 rows.2 cells for each row.
    – create datasource get from report.
    – each row i define title at firts cell, and get data of attribute from datasource.
    => after run template the output file is blank.
    i would like to check data source if the data is null i will pass 0 values for each cell above.
    Many thanks

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s