RegisterLog In to Jazz.net dW

It's all about the answers!

Ask a question

How to create data for using RTC Reports


jaya krishna (11634) | 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



link
James Moody (3.2k13) | answered Jan 21 '10, 2:23 p.m.
JAZZ DEVELOPER
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

link
jaya krishna (11634) | answered Jan 22 '10, 2:16 a.m.
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.

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

link
James Moody (3.2k13) | answered Jan 26 '10, 10:53 a.m.
JAZZ DEVELOPER
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

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.

link
jaya krishna (11634) | answered Jan 27 '10, 9:48 a.m.
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,

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

link
James Moody (3.2k13) | answered Jan 27 '10, 4:53 p.m.
JAZZ DEVELOPER
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


link
jaya krishna (11634) | answered Jan 28 '10, 10:35 a.m.
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,

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


link
James Moody (3.2k13) | answered Jan 28 '10, 1:08 p.m.
JAZZ DEVELOPER
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



link
jaya krishna (11634) | answered Feb 02 '10, 3:33 a.m.
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
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



link
James Moody (3.2k13) | answered Feb 03 '10, 2:23 p.m.
JAZZ DEVELOPER
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



link
jaya krishna (11634) | answered Feb 05 '10, 11:15 a.m.
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,

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


Your answer


Register or log in to post your answer.