Planned start and end date
Naveen Chandani (48●1●20●22)
| asked May 25 '12, 7:22 a.m.
retagged Jun 14 '13, 1:45 p.m. by Michael Prentice (62●2●9●13)
Hi,
I am using formal project management template for my project. I planned for a task for the duration of one week. After taking a snapshot of the plan, when I opened the task I saw the updated "Planned Start Date" & "Planned End Date". I would like to create a report in RRDI to show the planned start and end date for all such task. Where can I find these value, I mean in which table. |
5 answers
Hi Naveen, Hi Ali, I am looking for planned start and end date determined from the plan. The planned work table is giving me some no. in thousands. I am not sure about that no. whenever we create a workitem in a plan, we enter the estimate and the constraints. Based on the estimate and constraints, start and end date for the workitem is determined automatically by the system. I am looking for those date, which will be represented by two columns in RRDI. Regards, Naveen |
Hi Ali There can be many snapshots for a plan, but the snapshot of type planned is what needs to be considered as planned snapshot.
I do not know if the ETLs are updated to read the Plan Snapshot table. |
Hi Naveen,
Have a look at this page -> https://jazz.net/help-dev/clm/index.jsp?topic=%2Fcom.ibm.jazz.reports.doc%2Ftopics%2Fccm.html Under the section Work Item. It sounds like the attribute you might be looking for is PLANNED_WORK found in the REQUEST table of the Data Warehouse Regards, Ali |
|
Hi Naveen -
The PLANNED_WORK column is represented in minutes which is why you might see numbers in the thousands. Am looking into the second question about where the dates (planned start / planned end) are stored and either I or someone on the Insight team will hopefully respond soon. Regards, Ali |
The Planned Start Date and Planned End Date data is not in the work item tables. This has caused us all kind of headaches so far.
The following links should show you how to get at this data via the REST API. Unfortunately, RTC does not come with this data presented to you out of the box. You have to have your own team create a custom data mining project just to be able to use the tool for Formal Projects.
Here are threads about using the REST API to get out the data:
https://jazz.net/forum/questions/78335/is-there-rest-api-for-getting-resource-allocation-info
The last one suggests that the REST API was the only way to get the data that they needed.
This shows how to pull data out of the WorkItems API and the Planning (APT) API so that you can create the reports/displays that are needed. |
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.