CLM 4.0.3 - missing data in DW table RIODS.TIMESHEET
![]()
Hi,
I 've entered some values in a few work items regarding timesheet entries.
I can see report templates defined in project area as report resources and I can get data, but I can't find any data in DW table RIODS.TIMESHEET even I run ETLs data collection jobs twice.
I need this stuff for Cognos reporting.
Can someone tell me what I am doing wrong?
I also found this post:
https://jazz.net/forum/questions/114718/rtc-timesheet-reporting
and I checked also all mentioned tables, but I can't find any data.
I 've also upgraded RRDI from 2.0.1 to 2.0.3 version, and CLM from 4.0.1 to 4.0.3.
Thanks,
|
8 answers
![]()
Hello Milan,
apparently that feature didn't make it to 4.0.3 and is now planned for 4.0.4. See Defect 267768 ETL for Timesheet data Best Regards Francesco |
![]()
Hmmm,
that's not good news, because we were expecting that this will be supported with version 4.0.3.
Our management has been waiting for this last six months because they need reporting per timesheets in Cognos...
Any idea when the 4.0.4 GA will be released?
Regards.
|
![]()
Hello Milan,
according to the timeline in jazz.net for the RTC project area: 4.0.4 Final - Ends Sep 7, 2013. Of course this just gives an indication for now, not a confirmed release date. Best Regards Francesco |
![]()
Hi Francesco,
can you please confirm that this milestone
https://jazz.net/downloads/rational-team-concert/milestones/4.0.4M1?p=news
contains ETL for collecting data for DW RIODS.TIMESHEET table?
Because I want to download it and test reporting on Cognos.
Thanks,
|
![]()
Hello Milan,
Defect 267768 is marked as Fixed in 4.0.4M1 so, yes it should collect the time sheet data. Best Regards Francesco |
![]()
Hi Francesco,
I tested this ability, and I can't still see data in tables RIODS.TIMESHEET and RIODS.TIMESHEET_TIMECODE_LOOKUP. For all other tables mentioned in description, I can see data.
I've upgraded CLM 4.0.3 to 4.0.4 M1 and RRDI 2.0.3 to RRDI 2.0.4 M1, and I've done all necessary steps from this work item: https://jazz.net/jazz/web/projects/Rational%20Team%20Concert#action=com.ibm.team.workitem.viewWorkItem&id=262680&tab=rtc.planItem.v2.doneCriteria.section Comments Hello Milan
|
![]()
Milan, can you please contact IBM support, so they can setup a live session and invite development.
|
![]()
Actually only issues found in GA release should go through IBM Support via PMR channel, not beta release.
|
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.