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. |
4 answers
On 10/12/2009 11:38 AM, cjthorne wrote:
I am writing a custom report (using BIRT) and I would like to show the 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 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:
jmoodywrote: 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 |
|
|
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.