Is it possible with RRDI or Insight to report on the history of the latest result for a TER in RQM?
Is it possible to retrieve this info from the Data Warehouse and if yes, is there an example?
Thanks,
One answer
I am not sure if datawarehouse is able to collect history information about a artifact as the information about history of an artifact is not available outside RQM. This information is built at runtime using state information available within RQM. It should not be available with reporting datawerehouse.
Comments
Thanks Pramod for the response. I looked in the RQM Reporting Data Model and see under the Operational Data Store there are a few "Request History" tables and one called "Request State History". I'm just not sure exactly what's stored in these.
I don't think that is the history data you are looking for, although I am not expert of datawarehouse. However I reconfirmed that RQM does not expose history detail in REST API so I still assume dataware house can not have this info
One of the primary purposes of the data warehouse is to collect historical information so that it can be used for trending reports. That is the purpose of the nightly data warehouse data collection jobs. So the fact that historical information is not available from the RQM live data (via the REST API) does not imply that the historical information is not available in the data warehouse.
Comments
Michael Walker
Aug 24 '12, 1:11 a.m.bump bump bump
Michael Walker
Aug 27 '12, 2:30 p.m.bump bump bump
Geoffrey Clemm
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Jun 17 '13, 4:45 p.m.The data warehouse contains historical information for trend reports. But the data warehouse only contains what the ETL jobs store into it, so for RDDI, the question is whether the RQM ETL jobs collect the TER test results. With Rational Insight, you can customize the ETL jobs to store anything that is available from the live reports into the data warehouse, but you do need to be aware of how much data you end up storing in the data warehouse.