RRDi Challenges
![]()
Hi
We are using RTC 5.0
1) I would like to know if it is possible to report on multiple linking levels in one report, ie, Parent, Child, Grand Child and possibly Great Grandchild, ( 4 levels of linking)
2) Can we pull through the list of attachments attached to a specific work item into a report?
Any and all assistance will be greatly appreciated
Kind Regards
Glenn
|
Accepted answer
![]()
Hello Glenn,
#1 should be possible, you can build a query using: [Operational Data Store].[Request Area].[Request] [Operational Data Store].[Request Area].[Request Related Requests (by Relational Link)] to get one level of parent relationship. You can then duplicate it (by using copy / paste in the Queries view). If you join the 2 queries so that the request ID of the child of the first is equal to the request ID of the parent of the second, you can get a 3 level relationship, that you can expand in the same way to the 4th level #2 is not possible, as the attachments information is not stored in the data warehouse. See the Work Item entry of the data dictionary for reference: Work Item http://www.ibm.com/support/knowledgecenter/SSYMRC_5.0.2/com.ibm.team.reports.doc/topics/ccm/Work-Item.html Best Regards, Francesco Chiossi Glenn Watkins selected this answer as the correct answer
Comments Hi Fransesco
Thank you for taking the time to answer my questions.
In terms of point #2, in RTC I am able to run a query in the project area, and by adding "Attachments" using the "Column Display" I am able to expose the attached documents in a list format within the query. Currently we have over 50 project areas which means I would need to create this query in all project areas to get this information. I just need to see the summary (Name) of the attachment and not the content.
Would the same not be possible in RRDi?
Again I thank you for your time and attention to this.
Kind Regards
Glenn
1
![]() FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
A query runs against the live data (which has access to the attachments), while RRDI runs against the data warehouse, in which is stored only a subset of the live data.
In addition to Geoffrey's comment, that I completely agree with, the content of the subset of data is described in the data dictionary link, posted in my answer above.
|
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.