It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×42,860
×11,990

question asked: Apr 28 '15, 2:53 a.m.
question was seen: 2,809 times
last updated: Apr 29 '15, 5:39 a.m.

Related questions

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

0
Sandhya Prabhu (1●6●10) | asked 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

Accepted answer

0
permanent link
Lily Wang (4.9k●7●14) | answered 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
Comments
Ralph Schoon commented Apr 29 '15, 5:39 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

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

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Sandhya Prabhu (1●6●10) | answered 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
Comments
Lily Wang commented 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.

0
permanent link
Sandhya Prabhu (1●6●10) | answered 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

Your answer

Register or 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.