report for work items

openeis wrote:

we have many custom field for work items .And we need many reports .so
I want to develop some report .
Who can tell me which table store work items information?
I can get table name by db2 monitor.but I don't want to do.

My db is db2 .

Hello,

In RTC 1.0, the data warehouse does not store information about custom
work item fields. After 1.0 we will investigate some extensibility
around this item. In addition, the data sources which operate on "live"
data (from the repository, not from the warehouse) do not expose custom
fields.

Hope this helps.

james
Jazz Reports Team Lead

I don't understand it.
In general,warehouse data is from operated tables.
I needn't know warehouse tables name ,I only know operated tables.
For example,when I save a work item,it must insert into data the table, I only need to know this table.

openeis wrote:

I don't understand it.
In general,warehouse data is from operated tables.
I needn't know warehouse tables name ,I only know operated tables.
For example,when I save a work item,it must insert into data the
table, I only need to know this table.

When you save a work item, the data is saved in the repository, but it
is not saved in the data warehouse. Periodically, scheduled tasks run
and aggregate information about work items (and other artifacts),
storing the results in the data warehouse, but this aggregated
information does not include custom fields.

But I think you're asking about a larger issue, which is access to the
underlying database tables in the Jazz repository. This is not currently
possible - the underlying structures should be treated as opaque, and
data should be accessed through the appropriate APIs, such as the query
model. Perhaps someone from the repository team could comment on this.
We (the Reports team) do have a mechanism (a custom data source) to
connect BIRT-designed Reports to the repository artifacts by means of
the query model, but this data source does not currently support the
custom fields.

Hope this helps.

james
Jazz Reports Team Lead

Thank a lot.
I understand your comments.
And now I know the work item table,but the table data is encrypt.so I don't know how to get report by SQL .
who can help me?

I installed M6.And get "Designing a report template with BIRT tools" online help,but the docs is blank.(The Help content is a work in progress)
My question is :
Can BIRT tools access all field?

openeis wrote:

I installed M6.And get "Designing a report template with BIRT
tools" online help,but the docs is blank.(The Help content is a
work in progress)
My question is :
Can BIRT tools access all field?

The help topics are a work in progress. For now, you will find more
complete information on designing a report template in the wiki.

https://jazz.net/wiki/bin/view/Main/ReportsCreatingANewReport

Your question is a good one, and has two answers:
1. When using BIRT to access the Data Warehouse tables, you can access
all the fields that we actually store in the data warehouse. Remember,
though, that the warehouse is a storage mechanism for *aggregated*,
*historical* data, and as such does not include every field of every
artifact in the repository.

2. When using BIRT to access live data from the repository through our
special tables (such as the live work item counts table), this support
is built using the Jazz query model, which can access only those
attributes/fields which are marked as queriable in the respective model.

Hope this helps.

james

now I don't read docs of report
I want to know how to imp the following daily task report for our team in m6 :

categories ownerBy summary(groupbyweek(DueDay)) tags Defect

count(tags)

note:
my tags is failed,complete,blocked,ongoing.
now defect is not on rational team concert,after CMVC connector is ready,we need defect number.
categoried is part ,not all.

I think many reports is easy by SQL,but I don't know team concert report

Hello,

Could you clarify a couple of thing for me? I'm not sure I understand
exactly what you're asking.

- Are your defects actually in RTC? It sounds like they are currently in
CMVC, in which case we can't report on them.
- What do you mean by "categoried is part, not all"?
- I don't understand the list of criteria (categories, ownerBy...) -
could you be more specific about each of them?

Maybe it would be helpful if you could post a picture of what you would
like the report to look like.

Thanks,

james
Jazz Reports Team Lead

openeis wrote:

now I don't read docs of report
I want to know the following daily report for our team how to imp in
m6:

categories ownerBy summary(groupbyweek(DueDay)) tags Defect

count(tags)

note:
my tags is failed,complete,blocked,ongoing.
now defect is not on rational team concert,after CMVC connector is
ready,we need defect number.
categoried is part ,not all.

my example report :
platform tester week1(03/31-04/04) ...w9()
(category)

tookit_1 tester1 summary of task1 (failed)(defect 99999)

Solaris_2 tester2 summary of task2(complete)


category include platform and other category.

now defect is in CMVC,so now we don't need defect number

openeis wrote:

my example report :
platform tester w1(03/31-04/04) ...w9()
(category)

tookit_1 tester1 summary of task1 (failed)(defect 99999)

Solaris_2 tester2 summary of task2(complete)


category include platform and other category.

now defect is in CMVC,so now we don't need defect number

The reporting component is currently focused on reporting on data from
our data warehouse, which is collected from the Jazz repository. We
don't currently have any data sources that would allow you to collect
information from CMVC. BIRT does allow you to write custom data sources
- perhaps that would allow you to gather data from CMVC.

james