|
James Moody ( 3.3k●2●4)
| answered Feb 09 '10, 3:38 p.m.
JAZZ DEVELOPER
Hi Jay, Sorry for the delay getting back to you. The data that we store in the data warehouse doesn't currently have that granularity of information. We store information about stream size over time, and can do traceability from a work item to its change set, but from that change set you can only retrieve the number of files/folders, not the actual names. This is something we hope to address in 3.0. james RTC Reports Team Lead On 2/5/2010 11:23 AM, jayakrishna wrote: Hi James,
I am interested in generating report which would list out / shows what user 1 checked in by component by date.
Eg: User 1 has checked in File 1 for component 1 on 05feb2010 User 2 has checked in File 2, file 3, file 5 for component 2 on feb 042010.
I wanted to see the above example in a report. How do i achieve this.
Thanks in Advance.
Cheers, Jay.
jmoodywrote: Jay,
What kind of activity are you talking about? Work Items closed? SCM
Change Sets delivered? Some other metric?
james
On 2/2/2010 3:38 AM, jayakrishna wrote: Hi James,
Thanks for the reply.
I am looking for a report which would list component activity by User / Developer. Please help me in achieving the above report.
Cheers, Jay.
jmoodywrote: For #1, we don't have any out-of-the-box templates that show % complete for an iteration, but you could make such a report yourself with BIRT. Through the data tables you could fetch the work items for a particular iteration, and access the estimate (called "DURATION" in the table) and time spent columns to compute this information.
At the moment, we don't have any way to do traceability reports between work items and scm files, so you can't do #2 or #3 with our 2.x releases. See work item 85991, which asks for this capability.
Hope this helps.
james RTC Reports Team Lead
On 1/28/2010 10:38 AM, jayakrishna wrote: Hi James,
Thanks for the quick response.
Below is the detailed query on metrics which i am interested in.
1) How to generate a report which shows me % complete for particular iteration. eg: If i have 100 work items, Total effort defined is 100 hrs, effort spent already is 40 hrs, resources have spent only 30 hrs. Based on the above example i would like to see a report which is showing 40% completion where it should be 50%.
2) I need a Report which shows the tracebuility between workitems and files that have been changed by using the above work item. eg: workitem1 has been used for chaning 5 files during the deliver. The report should show the work item name and the above 5 files names.
3) Similary, If i want to see the files which are changed without associating any workitem in a report . how do i get this reported.
It would be great if you can provide me your solutions for the above scenarios. Thanks in Advance.
Regards, Jay.
jmoodywrote: On 1/27/2010 9:53 AM, jayakrishna wrote: Hi James,
I was very eager to see your reply. Thanks for the quick response. The way you gave us steps was very helpful. Now i am able to see the data and generate the reports using the templates. All the credit goes to you and RTC. I have couple of queries for you. 1. I am currently using RTC 2.0.0.1. Are there any new report templates which got added in newer or latest version of RTC. If yes, How do i get the newly added report templates to my current version without upgrading whole setup.
We didn't introduce any new reports in 2.0.0.2. We made some minor modifications and bug fixes to some of the existing ones, but nothing major.
2. Do we have any template or can we create any template which would display Effort Based Report for individual or Work item based.
Can you talk a little more about the types of metrics you'd like to see in such a report?
3. Without using Birt Tool, can i customize or Create new report templates using or without using existing templates. Note: Here i am interested in Adding new fields or new sections. I am interested in creating new .rptdesign file which has new fields and options. How do i acheive this.
You'll need to use the BIRT report designer to modify the existing report templates or create a new template.
Thanks in Advance.
Cheers, Jay.
jmoodywrote: Hi Jay,
Glad this helped.
The Project Activity Report presents data about source control (SCM)
which we store in our data warehouse. It turns out that this data collection can get expensive and isn't nicely scalable as a project gets more and more streams with more and more data in them. So we introduced a setting that lets you configure which streams this data is collected for. By default, the data is not collected for any streams, which explains what you're seeing here.
As a user with appropriate permissions, go to the Reports Web UI. Click on the "Administer SCM Snapshot" link (near the "Administer Data Warehouse" link in the left navigation panel). Check the checkbox beside the streams that you want to collect data for, and save the configuration.
Now, either wait until tomorrow, or manually trigger the snapshots (in the Administer Data Warehouse page). Then the report should show the data.
james RTC Reports Team Lead
On 1/22/2010 2:22 AM, jayakrishna wrote: Hi James,
Thanks for the Quick Response, The info provided by you was very helpful and i was able to achieve Build health report. I have created one build and run the build and now i am able to see the build Health.
I have one more query for you with regards to reports, Now i am interested in Project Activity Report under Source Control.
1. I have selected the Project Activity Report and opened the report. 2. I see Team Area, Stream, Components sections blank.
Observation: Under project activity report, I am not able to see any team area under team area section, Streams under streams section and components under components section.
Note: i have created team Area, streams and components. I assume i am missing something which would bring this data in reports.
In Short it would be great if you can answer my below queries. Questions to you: 1. How to create Team Area in context to Project activity Report. 2. How to Create Streams in Context to Project activity Report. 3. How to create Components in context to Project Activity Report. Where do i find the help for Reports apart from the help section. Thanks in Advance
Thanks& Regards, Jay.
jmoodywrote: On 1/21/2010 11:23 AM, jayakrishna wrote: Hi All,
I am new to RTC. I would like to use report templates which are present in Reports section. Below are the queries which i have:
Prerequisite: I have created a project assigned open up process template and created a team area and assinged few resources with developer roles.
1. Selected Reports -> shared reports folder - Build - Build Health Report. 2. Rightclicked on the above report and selected open option.
Observation: I see the Team Area as Blank.
Similarly when i select project activity report under source control.
Observation: I see Team Area, Stream, Component as Blank.
Note: Even though i have created teams, streams and components. I assue i am missing something which would bring this data in reports. Could you please explain how below queries:
Questions to you: 1. How to create Team Area in context to Reports. 2. How to Create Streams in Context to Reports. 3. How to create Components in context to Reports. Where do i find the help for Reports apart from the help section. It would be great if you can answer my above queries. Thanks in Advance.
Hi,
The list of team areas (etc.) that you see in the report parameters comes from the data warehouse. Furthermore, you'll only see data related to the build results that the report is going to present. By that I mean, you'll only see components which have (at least once) shown up in a build. You'll only see team areas that own one of these build definitions. So basically, I think you need to do the following:
1. Make sure you run at least one build... otherwise there's nothing to create a report on. 2. After you run the build, either wait overnight (when the data warehouse snapshots run) or force a manual execution of the snapshots
(in the reports web ui, under Data Warehouse Administration, if your user has the right repository permissions).
After this, the report should show some data in the parameters.
Hope this helps.
james RTC Reports Team Lead
|