It's all about the answers!

Ask a question

How to create data for using RTC Reports


jaya krishna (11612112) | asked Jan 21 '10, 11:21 a.m.
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



permanent link
James Moody (3.3k24) | 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




permanent link
michael white (61) | answered Aug 05 '10, 11:15 p.m.
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

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.