Project Area Linking to Plan Snapshot in RTC Schema
Hi,
I am trying to get the list of plan snapshots available in a specific project area by using the RTC "LIVE_SNAPSHOT" via BIRT Report.
Snapshot - LIVE_SNAPSHOT
Table - com.ibm.team.apt.snapshot.PlanSnapshot
com.ibm.team.apt.plansnapshot.BaselineMember
com.ibm.team.apt.plansnapshot.EstimateRollUp
com.ibm.team.apt.plansnapshot.PlanSnapshotType
com.ibm.team.apt.plansnapshot.ProcessItemBaselineMember
com.ibm.team.apt.plansnapshot.SizeRollUp
com.ibm.team.apt.snapshot.PlanSnapshot
In any of the above metioned tables i could not find the linking to the project area. Is there any column/attribute in this table that i can make use of for the filtering project areas based on ID ?
Is there any plan snapshot related table in the Data Warehouse Snapshots(other than Live Snapshot) that can be made utilized?
Please let me know. Thanks in advance
One answer
Sri, the LIVE_SNAPSHOT schema exposes the internal representation of the data in the CLM Repository. The schema also exposes only the indexed data that can be fetched efficiently. So it does not expose all the data.
We currently do not collect the snapshot data in the data warehouse.
We currently do not collect the snapshot data in the data warehouse.
Comments
Hi Rafik,
Thanks for your quick reply. May i know is there any way with the existing schema tables i could fetch the plan snapshots with respect to project area?
We have the feature in RTC plan Option to compare the snapshots.May i know from where the data for this comparison is been pulled from.i.e data source.Is there a way that i can used the same data source in BIRT?