Are the links between iterations in the datawarehouse?
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.
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
On 10/12/2009 11:38 AM, cjthorne wrote:
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
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
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.
On 10/14/2009 6:08 AM, ltsao wrote:
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
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