Team member roles in JRS
Hi,
Can we generate reports against team member roles (admin, business analyst, team member) in JRS? Thanks! |
2 answers
I'm sorry but the "Team" resources that RTC/RQM/DNG publish to LQE do not include the membership data. Therefore there is no data available to use team member roles in JRS reports for LQE data sources.
I believe the Data Warehouse does contain the team area membership and role data but the Report Builder UI does not expose the necessary types and relationships. In Report Builder, both DW and LQE reports expose team areas as an attribute of a Work Item which can be used for filtering. However, you might be able to write an advanced SQL query for the Data Warehouse to obtain the data you want but I am not familiar with the tables and columns in the DW where the team members and roles are stored. Comments Thanks Kevin.
I'll try the advanced query option.
hani zaidi
commented Nov 11 '16, 10:05 a.m.
Hi kevin, I am using DW as my datasource. The only exposed attribute here is team area and no further user details(absences, roles etc) can be fetched for reporting in JRS 6.0.2 |
Thanks Kevin.
I'll try the advanced query option.
|
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.