It's all about the answers!

Ask a question

Reporting data of time sheet with BIRT


Rice Well (30622723) | asked Jul 08 '11, 6:03 a.m.
Hi,

I have a question about report of BIRT.
I want to create a report which reports data of time sheet of workitem.
Amount of time in time sheet of each user etc.

Are there any good documents or articles I can refer to how to do that?
Or can I get any suggestions here?

13 answers



permanent link
Krzysztof Ka┼║mierczyk (7.4k35699) | answered Dec 04 '13, 1:29 a.m.
Hello,
Timesheet data has been added finally to datawarehouse. See https://jazz.net/forum/questions/114718/rtc-timesheet-reporting and https://jazz.net/downloads/rational-team-concert/milestones/4.0.4M1?p=news

permanent link
Rafik Jaouani (5.0k16) | answered Jul 12 '11, 10:02 a.m.
JAZZ DEVELOPER
The Timesheet data is not yet available to BIRT reports.

permanent link
Sean G Wilbur (87212421) | answered Oct 03 '11, 2:24 p.m.
JAZZ DEVELOPER
Rafik,

I thought this was just missing from the CLM DW, but still in the Data Mart. Is this data not in the LIVE_SNAPSHOT table com.ibm.team.workitem.TimeSheetEntry ?

-Sean

permanent link
James Moody (3.3k24) | answered Oct 05 '11, 8:38 a.m.
JAZZ DEVELOPER
This should be possible for BIRT using LIVE_SNAPSHOT, but it is unsupported; your mileage may vary. Note the link between the timesheetentry and the workitem is contained in the LINKS view in the COMMON_SNAPSHOT.

james
RTC Reports Team Lead

Rafik,

I thought this was just missing from the CLM DW, but still in the Data Mart. Is this data not in the LIVE_SNAPSHOT table com.ibm.team.workitem.TimeSheetEntry ?

-Sean

permanent link
Cesar Sasaki (511276120) | answered Oct 05 '11, 12:22 p.m.
Hi

I have made some reports with the timesheet, but in RTC 3.0 versions.
You have the right table, now link it with your requirement.

permanent link
Frederico Santiago (26) | answered Oct 11 '11, 1:56 p.m.
James,

I'm using com.ibm.team.workitem.TimeSheetEntry to get workitens timesheet data. I used com.ibm.team.links.AuditableLink passing com.ibm.team.workitem.linktype.timeSheetEntry as a parameter in the field "name" of this table. I did that to link workitem table with timeSheetEntry.

I created a JoinDataSet using these two tables and I got the correct rows. However I dont know which field represents "Calendar Date" of the timeSheetEntry.

In the table timeSheetEntry we have the Date fields listed below:

- creationDate
- startDate

The first one represents the first time that a DataSheet record is saved. So I cant use that.
Then I thought that the second field could represent the calendar date of the timesheetentry. In some cases it works well but sometimes something strange happens. The saved data, at startDate field, do not represent the date that appears on screen when I look at time sheet tracking.

Do you know which field I can use or if there is any other way to get this information?

Thank you

Frederico Gil


This should be possible for BIRT using LIVE_SNAPSHOT, but it is unsupported; your mileage may vary. Note the link between the timesheetentry and the workitem is contained in the LINKS view in the COMMON_SNAPSHOT.

james
RTC Reports Team Lead

Rafik,

I thought this was just missing from the CLM DW, but still in the Data Mart. Is this data not in the LIVE_SNAPSHOT table com.ibm.team.workitem.TimeSheetEntry ?

-Sean

permanent link
Frederico Santiago (26) | answered Oct 11 '11, 4:03 p.m.
I have noticed a strange behavior at BIRT dataset.
I have created a new work item. At timetrack I have informed a few spent hours in a day, for example, thursday.
When I generate the report at BIRT, it shows the correct results.

However, when I set spent hours for another day, the report shows these hours for the previous day I have informed.

For example, I have only informed 8 hours at thursday. The report is correct.
After, I have informed 8 hours for tuesday. The report shows these 8 hours in monday.

I have checked the dataset and I have confirmed that the date is always the date minus one.

I cant figure why this is happening.

Thank you.



James,

I'm using com.ibm.team.workitem.TimeSheetEntry to get workitens timesheet data. I used com.ibm.team.links.AuditableLink passing com.ibm.team.workitem.linktype.timeSheetEntry as a parameter in the field "name" of this table. I did that to link workitem table with timeSheetEntry.

I created a JoinDataSet using these two tables and I got the correct rows. However I dont know which field represents "Calendar Date" of the timeSheetEntry.

In the table timeSheetEntry we have the Date fields listed below:

- creationDate
- startDate

The first one represents the first time that a DataSheet record is saved. So I cant use that.
Then I thought that the second field could represent the calendar date of the timesheetentry. In some cases it works well but sometimes something strange happens. The saved data, at startDate field, do not represent the date that appears on screen when I look at time sheet tracking.

Do you know which field I can use or if there is any other way to get this information?

Thank you

Frederico Gil


This should be possible for BIRT using LIVE_SNAPSHOT, but it is unsupported; your mileage may vary. Note the link between the timesheetentry and the workitem is contained in the LINKS view in the COMMON_SNAPSHOT.

james
RTC Reports Team Lead

Rafik,

I thought this was just missing from the CLM DW, but still in the Data Mart. Is this data not in the LIVE_SNAPSHOT table com.ibm.team.workitem.TimeSheetEntry ?

-Sean

permanent link
Swathi Nulu (2621) | answered Feb 15 '12, 9:43 a.m.
Hi,

Timesheet data from RTc database is not get populated into Rational Insight dataware house

We have integrated RTC 3.0.1.1 and Rational Insight 1.0.1.1 and it get succeeded .We were running the following Job from datamanger to populate the data into RIDW.

We have duplicated the following job from CLM3.0.1_ALL job and deleted RQM nad RRC related jobs as our requirement is only to connect to Rational Team Concert .

JFS_ODS3.0.1_Deltaload-->RTC_ODS3.0.1_Deltaload--->Build_Star

We were able to see the data related to "workitems ,project areas and teamareas" .But we could not find the data
related to "Timesheet" entry .


Below are tables we re referring to verify the data in RIDW database for Timesheet data

TIMESHEET (RIODS schema) and TIMESHEET_TIMECODE_LOOKUP(RIODS schema)

Note:We are sure that we have some timesheet related data in our RTC database
Do we need to run any other jobs apart from the above job or we need to design our customized jobs ?

Please help us on this issue.

Thank You In Advance

With Regards,
Swathi N

permanent link
Rafik Jaouani (5.0k16) | answered Feb 18 '12, 8:01 p.m.
JAZZ DEVELOPER
Currently the timesheet data does not get pushed to the RIODS schema. This is under consideration in future releases.

permanent link
Swathi Nulu (2621) | answered Feb 20 '12, 1:47 a.m.
Currently the timesheet data does not get pushed to the RIODS schema. This is under consideration in future releases.


Hi Rafik,
Thanks a lot for your updates.But How ,I would be create "Userwise Resource Utilization Report "?Is there any way to achieve this ?

Thank You In Advance

With Regards,
Swathi N

Your answer


Register or to post your answer.