How do you pull data from RRC and RTC into one report?

Torin Denniston (15●7●10) | asked Mar 20 '14, 11:32 a.m.
edited Mar 20 '14, 11:34 a.m.

We have a series of questions related to pulling reports in RRDI:

1. How would one go about pulling data from multiple Jazz platforms (RRC and RTC) into one report? Using RRDI, we are unable to locate a primary key info or foreign key that relates a requirement in RRC that we’ve linked to a work item in RTC.

2. How do we gain access to the hidden lookup tables operating in the background of RRDI?

3. Does the Jazz Web UI access the data schema through SQL queries or an API?

Thank you!

Accepted answer

permanent link

Marc Nehme (276●5●7) | answered Mar 27 '14, 11:14 a.m.
JAZZ DEVELOPER

Hi Torin,

1) The CLM Java ETLs load data from the CLM tools (RTC, RQM and RRC) into the data warehouse. RRDI reads that data from the data warehouse. If your RRC and RTC environments belong to the same JTS and have existing artifacts that are linked to each other (eg a requirement is linked to a workitem), then the CLM Java ETLs automatically loads that relationship into the data warehouse.

To realize this relationship in Report Studio, I will provide an example
Create a new list report
Go to "Operational Data Store" > "Request Area"
Expand the "Request" query subject and drag the "Reference ID" (belonging to the work item) data item into your list report
Now go to the "Request Related Requirements" query subject and drag that "Reference ID" (belonging to the requirement) data item into your list report
Run the report and you should see a list of work item records (by ID) and the related requirement records (by ID)

2) Users do not have access to this using RRDI. The ETLs and framework are non-customizable. You need to upgrade to Rational Insight to have access to the developer tools which allow for complete customization of the ETL and framework data model.

Torin Denniston selected this answer as the correct answer

Comments

Torin Denniston commented Mar 27 '14, 11:17 a.m.

Thank you Marc! Do you know of any resource on the database side or within CLM that allows you to view how Web UI terms map to database terms? E.g. Work Item = Request.

Thanks again!

Marc Nehme commented Mar 27 '14, 11:29 a.m. | edited Mar 27 '14, 11:32 a.m.

JAZZ DEVELOPER

Hi Torin,

No problem.

Yes, we call these "data dictionaries" (main link): http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m5/index.jsp?re=1&topic=/com.ibm.rational.reporting.overview.doc/topics/c_reference_datadictionary.html&scope=null

Just select the CCM or RM data dictionary as needed from this page. We also provide the QM mappings for Rational Quality Manager. Then you simply select the resource you are interested in and we provide the end to end mapping for that resource. FYI, this is for v4.0.5. I am not sure what version of CLM you are running but you can find the equivalent in the other infocenters.

It's all about the answers!

Related questions

How do you pull data from RRC and RTC into one report?

Accepted answer

Your answer