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
#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
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
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.
1 vote
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.
Unluckily, the attachment information is not part of it.