It's all about the answers!

Ask a question

JRS Timesheet Reporting


Glenn Watkins (88245) | asked Aug 29 '16, 3:10 a.m.
 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

Comments
Glenn Watkins commented Aug 29 '16, 5:28 a.m.

 Hi


Is it possible to build a multi - generation report in JRS? I need to build a timesheet multi - generation report that is made up of a "Parent" and 5 "Children", the report needs to have both work item and timesheet related information, this means I would need to define at minimum 2 link types when building the report.

Is this possible

Kind Regards
Glenn Watkins

Accepted answer


permanent link
Kenji Sarai (96029) | answered Sep 04 '16, 9:50 p.m.
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.
Glenn Watkins selected this answer as the correct answer

Comments
Glenn Watkins commented Sep 05 '16, 3:03 a.m.

 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

One other answer



permanent link
Kenji Sarai (96029) | answered Sep 05 '16, 9:37 p.m.
Hi Glenn,

You can find the SQL query in Report Studio (Tools > Show Generated SQL/MDX). You may need to manipulate this query to fit in JRS, but certainly you will see what tables (views) are used for this report.

Comments
Glenn Watkins commented Sep 06 '16, 1:06 a.m.

 Hi Kenji


Thanks very much, really appreciate your assistance.

Kind Regards
Glenn

Your answer


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