It's all about the answers!

Ask a question

CLM 4.0.3 - missing data in DW table RIODS.TIMESHEET


Milan Krivic (9707155127) | asked Jun 28 '13, 10:44 a.m.
 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



permanent link
Francesco Chiossi (5.7k1719) | 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
Francesco

permanent link
Milan Krivic (9707155127) | answered Jun 28 '13, 11:04 a.m.
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.


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

permanent link
Milan Krivic (9707155127) | answered Jul 02 '13, 9:48 a.m.
 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,

permanent link
Francesco Chiossi (5.7k1719) | 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
Francesco

permanent link
Milan Krivic (9707155127) | 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: 
https://jazz.net/jazz/web/projects/Rational%20Team%20Concert#action=com.ibm.team.workitem.viewWorkItem&id=262680&tab=rtc.planItem.v2.doneCriteria.section

Comments
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 - dominic.franklin@in.ibm.com

Warm Regards
Dominic


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

permanent link
Susan Wu (4561815) | 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.