Default data warehouse based reports always returns nothing in RTC?
In RTC 4.0.x(tested in multiple versions), I tried to
1) create a Scrum PA 2) created a dozen of defects and tasks, set the priority/severity, and current iteration 3) run data collection jobs and it is successful 4) go to reports and run some data warehouse based reports such as "work items by priority report" New Work Items by Severity and Open Work Items by Type reports, it always returns: **** This report presents historical data from the data warehouse. This data is collected by automated data collection jobs. It is possible that this chart is empty because these jobs have not had a chance to run yet. To run the data collection jobs manually as an administrator, go to the Reports tab in the administrative web UI for the Jazz Team Server. Select the "Run all data warehouse collection jobs for all applications" link. After the jobs have completed, try viewing this report again. It is also possible that the selected parameters did not return any results from the data warehouse. **** The bottom will show the current iteration I set in the workitem. If I go to Edit and I see "my team area" and "current iteration" are checked by default. If I uncheck those two settings and run the report, everything will be returned, this means data warehouse has populated the data properly. Now if I run the same reports against JKE Banking, by default, it will always return some results. I go to edit and see the default settings are the same: "my team area" and "current iteration" are checked. In my own Scrum PA, if I keep "my team area" and "current iteration" checked and select all priority type, I still see blank result for "work items by priority report"(I thought priority may play some role here but it is not). If I create some team areas and set the work items to the new team areas and run data collection jobs, I still see "no result found" message with default settings("my team area" and "current iteration" checked). With the default settings only(not using edit to select/unselect anything else), why JKE Banking will always return the results but my own Scrum PA does not? Does anyone know what fields in the workitems(defect or task) would matter for these data warehouse based reports to be able to populate into the reports by default, just as how JKE Banking works? (manually edit the reports and select/unselect some parameters would generate the results, my question is for the default settings without any manual editing and why JKE Banking works but not my multiple PAs) Appreciate if anyone have a successful run and share the info. Many thanks. |
Accepted answer
The trend reports will only show the trend that falls between the earliest iteration start date and the latest end date depending on the selected iteration. So may you assigned work items to iterations that had already ended.
Don Yang selected this answer as the correct answer
Comments
Don Yang
commented May 03 '14, 12:46 a.m.
Thank you very much Rafik for this info.
Hi, Rafik
Don Yang
commented May 04 '14, 12:20 a.m.
Hi, Rafik
Very hard to tell by just looking at the above. If you have no team areas, then please uncheck the "My Team Areas" check box.
Don Yang
commented May 06 '14, 2:32 a.m.
Thanks Rafik.
|
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.
Comments
what does My Team Area mean? is your userid in the team area?
Thanks Sam.
I think My Team Area mean Project Area if there is no team areas created. I tried with Project area without team areas or with team areas, the result is the same: nothing found by default