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
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
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.
@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.
@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.
@Bala
- Ensure that there exists at least one project area with process equal to "Formal Project Management Process"
- For the project area selected, create several work items and assign Time Tracking information to them. (Note: The user needs to be logged as the owner of the work item to be able to add/modify Time Tracking information).
- Select a few of the previous work items, change the owner and assign additional Time Tracking information for that new user.
- Create new work items and assign additional Time Tracking information for the new user.
- Set to 'false' the 'ignoreTimesheetData' advanced server property.
- Execute the Data Collection jobs (at least Common and Work Items need to be run).
- Ensure that the Work Items ETL job ran successfully.
- If this is the first time that the Work Items ETL job is run, ensure that the Work Items Migration job was also successfully completed.
- Verify the tables listed in the Done Criteria to check that the timesheet information created in the previous steps has been properly populated.
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