Creating Timesheet report through RRDI or BIRT
Hello,
I'm trying to generate RRDI or BIRT report based on reported hours on the work-item time-sheet along with estimated and actual hours. Installed RRDI but not sure how to do I obtain the values to get the required values. Would it be possible to obtain the report through RRDI? If so, can some one help to understand database scheme to obtain the desired results? Are there any tech-note or reference available pertaining to RTC? Thanks in advance, Bala |
6 answers
The time sheets feature was specifically created for the Formal project management. Hence I doubt if this data is pulled into the warehouse by the data extraction ETLs.
|
Hi Bala. The TimeSheetEntry table (com.ibm.team.workitem.TimeSheetEntry) contains this information like internalTimeCode, internalTimeSpent. It is available through the LIVE_SNAPSHOT data source. The current version of my TimeSheet_Details report design is still not finished. I´ll share the concept version with you personally. The final version will be on this forum in the near future.
|
If it is not available through ETL, how do I obtain the data?
I guess the information being gathered through the work-item & it's being stored into the database but it would be nice getting the information through some means.. either through a query or report. Thanks, |
@Bala: after getting the same question from many users around the globe AND from clients I dived into BIRT reporting. BIRT or Business Intelligence Reporting Tool is the only NOT officially supported tool via which you can create Time Sheet overviews. I have created my first Time Sheet Report based on what I co-incidentally received from a colleague of the SWG. I plan to share this knowledge soon. There are some useful links that you should check. First three articles from Tim McMackin that helped me a lot: Creating custom reports with BIRT and Rational Team Concert: Part 1. Basic reports. There is this wiki on Rational Reporting with table info: TWiki - Datawarehouse Snapshot Schema´s and next to much more I would mention the BIRT Report Developer Guide.
@Aradhya: where can we find more explanation about the RTC table structure. For instance: I would NEVER come up with the idea to use the table Auditable_Links to link my time sheet entry (table: TimeSheetEntry) to my work items. Comments
Vivek Pandey
commented Jan 26 '13, 12:14 p.m.
Hi Alwin, What table / snapshot to use in BIRT for timesheet info ? and also if you can please share what is possible and what is not , it would be great help . |
Is there any way to create timesheet reports in Jazz Reporting Service?
Rafael.
|
@Bala
More information: https://jazz.net/jazz/web/projects/Rational%20Team%20Concert#action=com.ibm.team.workitem.viewWorkItem&id=262680&tab=rtc.planItem.v2.doneCriteria.section
|
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.