JRS Timesheet Reporting
Hi
We have just upgraded to CLM 6.0.2
Previously we used RRDi for our reporting function and I had managed to create a timesheet report that linked the work item to all the Time recorded against it, this included;
Timesheet Reporting Week
Timesheet Owner
Mon - Sun values
I was then able to perform calculation on the output for a given period.
How do I get the same in JRS?
Any and all assistance is greatly appreciated.
Kind Regards
Glenn Watkins
Accepted answer
Hi Glenn,
I have some idea for your first question. There are two possible solutions.
1. Given that you already have a report you want in RRDI (I am not sure if this is possible in RRDI, though), you can theoretically create the same report in JRS, because RRDI and JRS are sharing the same data warehouse schema. In JRS Advanced tab, you can input any kind of SQL query manually for the report. Firstly, find the query in your current RRDI report (by Report Studio), analyse what table/join are used, and then copy this query into JRS Advanced tab.
2. JRS 6.0.2 introduces workitem/timesheet report. So you do not need to manually modify the SQL query. See "Creating timesheet reports" below for detail.
https://jazz.net/downloads//jazz-reporting-service/releases/6.0.2?p=news
The view RICALM.VW_TIMESHEET_ENTRY is introduced in 6.0.2 and used to join with workitem (RIDW.VW_REQUEST).
Hope it helps.
I have some idea for your first question. There are two possible solutions.
1. Given that you already have a report you want in RRDI (I am not sure if this is possible in RRDI, though), you can theoretically create the same report in JRS, because RRDI and JRS are sharing the same data warehouse schema. In JRS Advanced tab, you can input any kind of SQL query manually for the report. Firstly, find the query in your current RRDI report (by Report Studio), analyse what table/join are used, and then copy this query into JRS Advanced tab.
2. JRS 6.0.2 introduces workitem/timesheet report. So you do not need to manually modify the SQL query. See "Creating timesheet reports" below for detail.
https://jazz.net/downloads//jazz-reporting-service/releases/6.0.2?p=news
The view RICALM.VW_TIMESHEET_ENTRY is introduced in 6.0.2 and used to join with workitem (RIDW.VW_REQUEST).
Hope it helps.
Comments
Hi Kenji
Thanks very much for taking the time to respond to my question, really appreciated.
I have opened our previous report that was created in RRDI, it allows me to copy it to clipboard, however it copies in .xml format, is there a way I could see and inspect the SQL query in RRDI?
Kind Regards
Glenn
Comments
Glenn Watkins
Aug 29 '16, 5:28 a.m.Hi