Is Personal Timesheet report parameter from DW or not?
RTC5.0.1 used.
In the help(http://www-01.ibm.com/support/knowledgecenter/SSYMRC_5.0.1/com.ibm.team.reports.doc/topics/r_report_templates_oob.html?cp=SSYMRC_5.0.1), it says timesheet reports are DW type. So I assume that it means the parameters will be populated after etl job is run successfully.
In my test here, I added a new user Bob to the member of project area and login with Bob to create a new task in formal process managed PA and add time tracking entry as well.
Now I go to Personal Timesheet report and I notice that newly added user Bob is listed under User's field without running etl job. I am confused now: do the timesheet report's parameters such as project area and user retrieve the data live from Database or they should be from DW?(I tried to change advanced server property " Ignore Timesheet Data" from true to false and tested again without restarting server, still the data will show up with no etl jobs running).
Can anyone please advise? thanks
In the help(http://www-01.ibm.com/support/knowledgecenter/SSYMRC_5.0.1/com.ibm.team.reports.doc/topics/r_report_templates_oob.html?cp=SSYMRC_5.0.1), it says timesheet reports are DW type. So I assume that it means the parameters will be populated after etl job is run successfully.
In my test here, I added a new user Bob to the member of project area and login with Bob to create a new task in formal process managed PA and add time tracking entry as well.
Now I go to Personal Timesheet report and I notice that newly added user Bob is listed under User's field without running etl job. I am confused now: do the timesheet report's parameters such as project area and user retrieve the data live from Database or they should be from DW?(I tried to change advanced server property " Ignore Timesheet Data" from true to false and tested again without restarting server, still the data will show up with no etl jobs running).
Can anyone please advise? thanks
Accepted answer
One other answer
This is the SQL statement the get the contributor list for the Personal Timesheet report, which looks to be the live data.
select distinct t2.NAME, t3.NAME from MODEL.TIME_SHEET_ENTRY t1 inner join PROCESS.PROCESS_AREA t2 on (t1.PROJECT_AREA_ITEM_ID = t2.ITEM_ID) left outer join REPOSITORY.CONTRIBUTOR t3 on (t1.CREATOR_ITEM_ID = t3.ITEM_ID) where ((t2.ARCHIVED = 0) or t2.ARCHIVED is null )Probably the document is incorrect?