Reporting data of time sheet with BIRT

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

The Timesheet data is not yet available to BIRT reports.

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

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

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.

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

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

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

Currently the timesheet data does not get pushed to the RIODS schema. This is under consideration in future releases.

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