Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Is it possible with RRDI or Insight to report on the history of the latest result for a TER in RQM?

Questions
Tags
Users
Badges
Michael Walker
(992●15●202●157) edited
Aug 23 '12, 10:21 a.m.
I created a RRDI report for a customer that lists the progress of the latest result of each TER for a testcase based on points passed or points attempted.  They'd also like to see the history of those points changed in the result and I noticed in the History tab it shows the points that changed and date it occurred.

Is it possible to retrieve this info from the Data Warehouse and if yes, is there an example?
Thanks,

0 votes

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.

1 answer
11,021 views
0 votes

One answer

Permanent link
Pramod Chandoria
JAZZ DEVELOPER (2.1k●1●12●20) Aug 28 '12, 12:19 p.m.
Hi Mike
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.

0 votes

Comments
Michael Walker
Aug 28 '12, 6:45 p.m.
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.

Pramod Chandoria
JAZZ DEVELOPER Aug 29 '12, 12:08 p.m.
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

Geoffrey Clemm
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Jun 17 '13, 4:49 p.m.
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.

Your answer

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

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,144
× 7,622
× 403

Question asked: Aug 23 '12, 3:58 a.m.

Question was seen: 11,021 times

Last updated: Jun 17 '13, 4:49 p.m.

Confirmation Cancel Confirm