It's all about the answers!

Ask a question

Are the links between iterations in the datawarehouse?


Colin Thorne (22421619) | asked Oct 12 '09, 11:33 a.m.
I am writing a custom report (using BIRT) and I would like to show the relationship between iterations. For example, I have an overall development line, then several month long iterations, each of which have two child iterations. I can see this relationship under the plans view in RTC Eclipse client (or in the project area timelines where I can change these details).

Is it possible to find the relationship (parent, child) between these iterations in the data warehouse? I have tried to use both the Common Snapshop 'Links' table, and the Live data source table called 'com.ibm.team.links.AuditableLink' but I cannot find any of the iteration links.

The schema description for the Common Snapshot 'Links' (https://jazz.net/wiki/bin/view/Main/DataWarehouseSnapshotSchemas20) says that it holds all the relationships between 'items' in the warehouse, but perhaps an iteration is not an 'item', or perhaps I am not trying hard enough to find the links :-)

Thanks, Colin.

4 answers



permanent link
James Moody (3.3k24) | answered Oct 13 '09, 1:48 p.m.
JAZZ DEVELOPER
On 10/12/2009 11:38 AM, cjthorne wrote:
I am writing a custom report (using BIRT) and I would like to show the
relationship between iterations. For example, I have an overall
development line, then several month long iterations, each of which
have two child iterations. I can see this relationship under the
plans view in RTC Eclipse client (or in the project area timelines
where I can change these details).

Is it possible to find the relationship (parent, child) between these
iterations in the data warehouse? I have tried to use both the Common
Snapshop 'Links' table, and the Live data source table called
'com.ibm.team.links.AuditableLink' but I cannot find any of the
iteration links.

The schema description for the Common Snapshot 'Links'
(https://jazz.net/wiki/bin/view/Main/DataWarehouseSnapshotSchemas20)
says that it holds all the relationships between 'items' in the
warehouse, but perhaps an iteration is not an 'item', or perhaps I am
not trying hard enough to find the links :-)

Thanks, Colin.


Hi Colin,

Unfortunately the hierarchical structure of iterations is not stored in
the data warehouse presently. (i.e. in the ITERATION table of
COMMON_SNAPSHOT). Iterations are indeed items, but the relationship
between iterations is not stored using links. The fields holding the
parent/child relationships is also not exposed by Jazz's query model,
which means that you can't use the LIVE_SNAPSHOT, table
com.ibm.team.process.Iteration, to get this information either.

james
RTC Reports Team Lead

permanent link
Lewis Tsao (2174963) | answered Oct 14 '09, 6:04 a.m.
On 10/12/2009 11:38 AM, cjthorne wrote:
I am writing a custom report (using BIRT) and I would like to show the
relationship between iterations. For example, I have an overall
development line, then several month long iterations, each of which
have two child iterations. I can see this relationship under the
plans view in RTC Eclipse client (or in the project area timelines
where I can change these details).

Is it possible to find the relationship (parent, child) between these
iterations in the data warehouse? I have tried to use both the Common
Snapshop 'Links' table, and the Live data source table called
'com.ibm.team.links.AuditableLink' but I cannot find any of the
iteration links.

The schema description for the Common Snapshot 'Links'
(https://jazz.net/wiki/bin/view/Main/DataWarehouseSnapshotSchemas20)
says that it holds all the relationships between 'items' in the
warehouse, but perhaps an iteration is not an 'item', or perhaps I am
not trying hard enough to find the links :-)

Thanks, Colin.


Hi Colin,

Unfortunately the hierarchical structure of iterations is not stored in
the data warehouse presently. (i.e. in the ITERATION table of
COMMON_SNAPSHOT). Iterations are indeed items, but the relationship
between iterations is not stored using links. The fields holding the
parent/child relationships is also not exposed by Jazz's query model,
which means that you can't use the LIVE_SNAPSHOT, table
com.ibm.team.process.Iteration, to get this information either.

james
RTC Reports Team Lead

Following on from Colin's request, can I suggest that the whole issue of what is exposed to end user be looked at. Many users will want to write custom reports for diverse requirements.

More information should be made available or exposed to end user.

permanent link
James Moody (3.3k24) | answered Oct 14 '09, 9:14 a.m.
JAZZ DEVELOPER
On 10/14/2009 6:08 AM, ltsao wrote:
jmoodywrote:
On 10/12/2009 11:38 AM, cjthorne wrote:
I am writing a custom report (using BIRT) and I would like to show
the
relationship between iterations. For example, I have an overall
development line, then several month long iterations, each of which
have two child iterations. I can see this relationship under the
plans view in RTC Eclipse client (or in the project area timelines
where I can change these details).

Is it possible to find the relationship (parent, child) between
these
iterations in the data warehouse? I have tried to use both the
Common
Snapshop 'Links' table, and the Live data source table called
'com.ibm.team.links.AuditableLink' but I cannot find any of the
iteration links.

The schema description for the Common Snapshot 'Links'

(https://jazz.net/wiki/bin/view/Main/DataWarehouseSnapshotSchemas20)
says that it holds all the relationships between 'items' in the
warehouse, but perhaps an iteration is not an 'item', or perhaps I
am
not trying hard enough to find the links :-)

Thanks, Colin.


Hi Colin,

Unfortunately the hierarchical structure of iterations is not stored
in
the data warehouse presently. (i.e. in the ITERATION table of
COMMON_SNAPSHOT). Iterations are indeed items, but the relationship
between iterations is not stored using links. The fields holding the
parent/child relationships is also not exposed by Jazz's query model,

which means that you can't use the LIVE_SNAPSHOT, table
com.ibm.team.process.Iteration, to get this information either.

james
RTC Reports Team Lead


Following on from Colin's request, can I suggest that the whole issue
of what is exposed to end user be looked at. Many users will want to
write custom reports for diverse requirements.

More information should be made available or exposed to end user.


Indeed. In RTC 3.0, we are writing a set of Reportable REST APIs which
can be used to extract data from the RTC repository and either (1) store
it in an enterprise data warehouse, such as Insight, or (2) directly
generate reports using tools which support these APIs, such as Cognos.
This improvement should go a long way towards enabling reporting
scenarios that aren't possible today. In addition, if there are
*specific* cases which fail today (such as the one mentioned above),
we'd like to know about them so we can ensure they get addressed.

james
RTC Reports Team Lead

permanent link
melina dee (16) | answered Dec 14 '09, 3:44 p.m.
discussionis good and thanx for posting the information
Data Entry India

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.