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

Timesheet ETL in Rational Insight 1.1.1.2 and CLM 4.03

Questions
Tags
Users
Badges
Kunal Bajaj
(26●8●10) Feb 18 '14, 5:46 p.m.
Were the Timesheet reporting ETLs a part of Rational Insight 1.1.1.2? I see conflicting posts on this. Can someone from IBM please respond and confirm what the current status is? 

If this was not rolled out, is there a work around or a patch? Thanks.

0 votes

4 answers
8,664 views
0 votes

4 answers

Permanent link
Francesco Chiossi
(5.7k●1●11●19) Feb 19 '14, 6:13 a.m.
Hello Kunal,

this is what I found in the last version of the info center:

Note: For Data Manager, the Timesheet job is included in the Work Item job and is disabled by default. An additional job, Timesheet4.0.3_FullLoad , is included. You must run this job before enabling the Timesheet job within the Work Item job.
See:

Running the data collection jobs
http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m5/topic/com.ibm.rational.reporting.admin.doc/topics/t_running_the_data_collection_jobs.html

Best Regards,

Francesco Chiossi

0 votes

Permanent link
Kunal Bajaj
(26●8●10) Feb 19 '14, 10:33 a.m.
 Francesco,

Thanks for the response. The link you mentioned is for Rational Reporting 4.05. In Rational Insight 1.1.1.2, in Data Manager, there does not appear to be a Timesheet4.0.3_FullLoad job. Would you be able to provide the location of this job? If it is not included, is there a way to export the job from your environment and import it into ours?

0 votes

Permanent link
Marc Nehme
JAZZ DEVELOPER (276●1●5●7) edited
Feb 20 '14, 12:41 p.m.
Hi Kunal,

The Timesheet job is indeed there for RTC v4.0.3. First, ensure that you are using the updated .PKG file for RTC v4.0.3 which can be downloaded from your ccm/admin > Reports page. http://pic.dhe.ibm.com/infocenter/rentrpt/v1r1m1/index.jsp?topic=%2Fcom.ibm.rational.raer.integration.doc%2Ftopics%2Ft_integrate_clm_package.html

Once you ensure you have downloaded that PKG file and imported it into your Data Manager catalog, in Data Manager, navigate to Builds and Jobstreams > Jobs > RTCJobs > RTC4.0.3Jobs and you will find the RTC_Timesheet4.0.3 job there.



It is disabled by default and referenced in the RTC_Workitem4.0.3 job:

0 votes

Comments
Marc Nehme
JAZZ DEVELOPER Feb 24 '14, 3:27 p.m.
Kunal, it appears there is some confusion with the versioning of the jobs. I was looking at my 405 catalog when I replied above. The 405 catalog shows the Timesheet jobs nested and labeled 403 (see pic above). The 403 Timesheet job also references 401 builds. I am getting clarity from Dev on this confusing nomenclature. Apologies for the confusion. I would think if the builds were only available in 404, then we would label them with v404 and not 403. We will update you through PMR once we get some clarity from Dev.

Marc Nehme
JAZZ DEVELOPER Feb 24 '14, 4:36 p.m.
Kunal, please contact Support to see if you can get an export of the Timesheet job so you can import it into your environment. Dev confirmed will run against a 403 environment.

Permanent link
Marc Nehme
JAZZ DEVELOPER (276●1●5●7) Mar 05 '14, 4:27 p.m.
Kunal, I have tested this and it works fine. You need to obtain the Timesheet job package from support and import it. Run the full load (RTC_Timesheet4.0.3_FullLoad) the first time. Once that completes successfully, append "RTC_Timesheet4.0.3" it to the RTC_Workitem4.0.3 job as the second to last node before the "Finish" procedure.

0 votes

Comments
Marc Nehme
JAZZ DEVELOPER Mar 17 '14, 2:09 p.m.
Please note that IBM has confirmed that this is indeed considered a customization and you must own the solution. If you are interested in implementing this, please do not open a PMR with IBM Support. I have listed the process on how to implement this in my blog: http://marcnehme.com/blog/?p=89

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.

Ask a question
Guidelines
FAQ
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
× 11,102

Question asked: Feb 18 '14, 5:46 p.m.

Question was seen: 8,664 times

Last updated: Mar 17 '14, 2:09 p.m.

Confirmation Cancel Confirm