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

Is it possible to extract Planned Start Date and Planned End Dates in Reports?

Questions
Tags
Users
Badges
Sandhya Prabhu
(1●6●10) Apr 28 '15, 2:53 a.m.
Hi,

Is it possible to extract Planned Start Date and Planned End Dates of Task Work Items  in Reports as I do not see these attributes under columns section while building JRS Report. Is there any alternate way to extract ? Please suggest.

Thanks,
Sandhya

0 votes

3 answers
3,020 views
0 votes

Accepted answer

Permanent link
Lily Wang
(4.9k●7●14) Apr 28 '15, 9:29 p.m.
Hi Sandhya,

The Planned Start Date and Planned End Date are calculated data which are not stored in work item but in plan. Those data are not collected in data warehouse by default.
If you are using BIRT or RRDI report, it's not possible to extrace Planned Start Date and Planned End Date.

There are some similar discussion for your reference:
https://jazz.net/forum/questions/86027/insight-how-to-extract-planned-start-date-and-planned-end-date
https://jazz.net/forum/questions/142596/birt-report-datasourcesnapshottable-for-planned-start-and-end-date-in-formal-project-planning
Ralph Schoon selected this answer as the correct answer

0 votes

Comments
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Apr 29 '15, 5:39 a.m.

I would suggest to create an enhancement request to get the plan snapshot data into the data warehouse. This data is frozen if you create a plan snapshot and the only data available for the data collection jobs, as the life data is calculated online in the plan.

2 other answers

Permanent link
Sandhya Prabhu
(1●6●10) Apr 29 '15, 2:16 a.m.


    Thanks Lily How about using JRS .. is there  a way out using SQL query?

please suggest.
Thanks
Sandya

0 votes

Comments
Lily Wang
Apr 29 '15, 2:28 a.m.

JRS is also extract data from data warehouse, so I don't think you can get the data using JRS report.

Permanent link
Sandhya Prabhu
(1●6●10) Apr 29 '15, 2:16 a.m.


    Thanks Lily How about using JRS .. is there  a way out using SQL query?

please suggest.
Thanks
Sandya

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.

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
× 12,019

Question asked: Apr 28 '15, 2:53 a.m.

Question was seen: 3,020 times

Last updated: Apr 29 '15, 5:39 a.m.

Confirmation Cancel Confirm