Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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,


0 votes



8 answers

Permanent link
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

0 votes


Permanent link
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.

0 votes


Permanent link
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

0 votes


Permanent link
 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,

0 votes


Permanent link
Hello Milan,

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

Best Regards
Francesco

0 votes


Permanent link
  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

0 votes

Comments

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
Milan, can you please contact IBM support, so they can setup a live session and invite development.

0 votes


Permanent link
Actually only issues found in GA release should go through IBM Support via PMR channel, not beta release.

0 votes

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,019
× 7,496

Question asked: Jun 28 '13, 10:44 a.m.

Question was seen: 7,852 times

Last updated: Jul 24 '13, 11:15 a.m.

Confirmation Cancel Confirm