It's all about the answers!

Ask a question

CLM 4.0.3 - missing data in DW table RIODS.TIMESHEET

Milan Krivic (98013176142) | asked Jun 28 '13, 10:44 a.m.

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:

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.


8 answers

permanent link
Francesco Chiossi (5.7k11119) | answered Jun 28 '13, 10:56 a.m.
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

permanent link
Milan Krivic (98013176142) | answered Jun 28 '13, 11:04 a.m.

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?


permanent link
Francesco Chiossi (5.7k11119) | answered Jun 28 '13, 11:11 a.m.
Hello Milan,

according to the timeline in 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

permanent link
Milan Krivic (98013176142) | answered Jul 02 '13, 9:48 a.m.
 Hi Francesco, 

can you please confirm that this milestone

contains ETL for collecting data for DW RIODS.TIMESHEET table?

Because I want to download it and test reporting on Cognos.


permanent link
Francesco Chiossi (5.7k11119) | answered Jul 09 '13, 6:13 a.m.
Hello Milan,

Defect 267768 is marked as Fixed in 4.0.4M1 so, yes it should collect the time sheet data.

Best Regards

permanent link
Milan Krivic (98013176142) | answered Jul 15 '13, 8:07 a.m.
  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:

Dominic Franklin commented Jul 24 '13, 11:15 a.m.

Hello Milan

Would you like to see if you can be onboarded to the Managed Beta for 4.0.4?
If yes, please send me a note from your business mailbox to my email -

Warm Regards

permanent link
Rafik Jaouani (5.0k16) | answered Jul 15 '13, 7:35 p.m.
Milan, can you please contact IBM support, so they can setup a live session and invite development.

permanent link
Susan Wu (4712116) | answered Jul 24 '13, 9:29 a.m.
Actually only issues found in GA release should go through IBM Support via PMR channel, not beta release.

Your answer

Register or to post 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.