RQM Query vs Report Builder
Hi All
Could you explain me, why the query possibilities in RQM and in Report Builder are different?
E.g. for Test Results the Attributes "Tested by" and "Current" are not available in Report Builder
On the other side, in RQM "Browse Test Results" view it is the test case categories that are not visible, only the test case custom attributes.
It is quite annoying that I need to run a query in RQM and in Report Builder as well, and merge them in Excel to have the complete test protocol that I need.
Are these limitations designed by intention?
Thanks for your answers
Gabor
One answer
Hi Gabor,
Report Builder reports on data from Rational Data Warehouse or Lifecycle Query Engine, while the query in RQM you mentioned query application RQM data base.
https://www.ibm.com/support/knowledgecenter/SSCP65_6.0.3/com.ibm.rational.reporting.overview.doc/topics/c_ovr_arch_dw.html
The Data Warehouse data is loaded by data collection jobs, such as the Data Collection Component (DCC), from Rational® solution for Collaborative Lifecycle Management (CLM) applications.
https://www.ibm.com/support/knowledgecenter/SSCP65_6.0.3/com.ibm.rational.dcc.doc/topics/c_ovr_process_etl_rrdi.html
Not all application data is loaded into data warehouse. To find out which data loaded to data warehouse, please refer to CLM Data Dictionary
https://www.ibm.com/support/knowledgecenter/SSCP65_6.0.3/com.ibm.rational.reporting.overview.doc/topics/c_reference_datadictionary.html
CLM includes a data warehouse, to which each of the CLM applications contribute data. The data dictionary topics in this section detail the relationship between application-specific data (physical data related to artifacts and other elements in CLM applications) and the related queries that need to be incorporated into a report so that the required application data appears in the report output.
Hope this helps.