How to create data for using RTC Reports
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. |
12 answers
Hi,I'm a fresh in Jazz Report.
I just watched the video<<how>>. 1 And I just can not find the "Jazz Data Source" when I wanna create a "Data Source".Could you help me to fix it? 2 And after I install the birt-freamork2.3.2.2 into my RTC2.0,the RTC2.0 just can not start.How to deal with this one? Send me a mail please if you know how to fix it,thx so much. address: baiboyang@gmail.com |
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, |
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. Jay, Hi James, |
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, |
Hi James,
Thanks for the reply. It would be great if you can answer my below queries as well. 1) I am looking for a report which would list component activity by User / Developer. 2) I want a report which would list out the details of a each work item in a single page. eg: Print single Record in Clear Quest.ie: which has Defect ID, Project, status, headline, version, detection information, review / assign information, target version, resolution information, build information, verification information, and description. Similary i want report in RTC for single Work item which would lists out all the details of that work item. 3) Under work items, when i create a query and run the query i am displayed with the result under work items tab. Which is great. Here what i am interested is how do i configure the output columns. ie: Assume that i want the output to have only specific columns (eg: ID, Status, Severity and Summary) Similary how do i achieve the same in Web. I have also observed there is difference in the columns both in RTC client and RTC WEb ie: RTC Client has below sections when i run query: Type, ID, Status, Priority,Severity, Summary, creted by, owned by In where as in RTC WEb i have observed below columns when i run the query: Type, ID, Summary, Owned by, status, priority, severity,modified date and actions. Why does this differ, does that mean they are using diffent templates ? Here what i am interested is where do i configure or define the columns that needs to be dispalyed in the output. It would be great if you can list me step by step process for all the above sections. Please help me in achieving the above report.Thanks in Advance Cheers, Jay. For #1, we don't have any out-of-the-box templates that show % complete Hi James, |
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, |
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. On 1/27/2010 9:53 AM, jayakrishna wrote: Hi James, 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 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 You'll need to use the BIRT report designer to modify the existing report templates or create a new template.
|
On 1/27/2010 9:53 AM, jayakrishna wrote:
Hi James, 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 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 You'll need to use the BIRT report designer to modify the existing report templates or create a new template.
|
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. 2. Do we have any template or can we create any template which would display Effort Based Report for individual or Work item based. 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. Thanks in Advance. Cheers, Jay. Hi Jay, Hi James, |
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, Comments
Jeff Foege
commented Jun 18 '12, 6:58 p.m.
James, I'm having trouble follow what you said" 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." That link isn't there in RTC 3.0.1. All I want to do is verify the data collection is happening on the new streams/projects that I've created. |
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.