I want get ETC hours for a resource month wise. How can I get it?
see the attached file. I have marked the data i need from a sql query.
please let me know which table & field can help me to get the data.
Thanks in advance.
Have a look in table prj_blb_slices_m_etc ... investment_id is project id ... resource_id is there ... Slice_Date are months and Slice column contains the ETC .... divide by number of hours (resource availability) to get the ETC in days. There are similar tables to get weekly or Daily ETC data.
I hope this will help.
Though comperedto the way your view is configured those slices are for calendar months and not months starting at th 14th.
One doubt - If I goto Data Administration>>Time Slices and search for a timeslice with Estimates as its item, I get only the below four of which one is a monthly curve.
Seeing your reply above, I checked the prj_blb_slicerequests table and got the two slices from the table as given below:
They both look almost the same except for the rollover frequency which is monthly for one and quarterly for the other.
Are there any other differences between these two system slices? Which one should we prefer to use in such a scenario to get our required data?
If you look at more fields you can see that the slice 113 is synchronous. That is it is instaslice and not updated with the time slicing job. Those slices a re used in many of the system views like weekly detail. They are system defined and the user cannot change the definition in the GUI. If the user deed data outside the instaslices (the time period requested does not exist - situation) then the option is to use the user configurable slices and to configure them to cover the time frame needed.
Martti already explained above ... Data is present in both tables.It only depends what sort of data you are looking for. I just pointed Pragya into right direction. They need to explore the tables according to their needs...
I look for the table prj_blb_slices_m_etc. It gave me data for ETC. but I found multiple rows for ETC for same resource & project for same slice_date. the only difference is in prj_object_id. so what does prj_object_id indicate here?
and how I can differentiate which one I should pick. and why it is showing multiple records?
I have attached file for your referece.
Thanks for reply & waiting for your input.
Thanks.@ ! !
ETC is not a function of project and resource and date, it is a function of the assignment and date.
In other words; project id / resource id / date are not unique enough to define the level that the data is held ; the data relates to assignment records.
(explicitly, for this particular slice, the prj_object_id is prassignment.prid)
Retrieving data ...