From which ODS table in RRDI 2.0 ( with CLM4.0) , I can get Proposed Start Date , Proposed End Date , Planned Start Date , Planned End Date
![](http://jazz.net/_images/myphoto/6228f662eff8f8e47ce3125eed5edd81.jpg)
RRDI 2.0 has been installed and integrated with CLM 4.0 . I have used Formal Process in RTC . Taken Proposed Snapshot with estimates for a setsof workitems. Modified estimates for few workitems then taken Planned snapshots . My question how and from which ODS table in RRDI 2,0 , I can get Proposed Start Date , Proposed End Date , Planned Start Date , Planned End Date fields .
Thanks & Regards
PKC
Thanks & Regards
PKC
2 answers
![](http://jazz.net/_images/myphoto/6228f662eff8f8e47ce3125eed5edd81.jpg)
Hello
try these data dictionaries available in the infocenter: http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m3/topic/com.ibm.team.reports.doc/topics/ccm-roles.html
And this is what is populated in the FM model by CLM apps: http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m3/topic/com.ibm.rational.reporting.overview.doc/topics/c_reference_datadictionary_clmmetrics.html
try these data dictionaries available in the infocenter: http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m3/topic/com.ibm.team.reports.doc/topics/ccm-roles.html
And this is what is populated in the FM model by CLM apps: http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m3/topic/com.ibm.rational.reporting.overview.doc/topics/c_reference_datadictionary_clmmetrics.html
![](http://jazz.net/_images/myphoto/6228f662eff8f8e47ce3125eed5edd81.jpg)
Hi PKC,
I believe those dates are not visible outside of plans so not pushed to the DW as they are calculated internal values for the plan snapshots.
Having said that I don't know if you have seen the GADO Focal Point-CLM integration? This uses an internal service to pull a couple of details from a plan snapshot. It doesn't go into the DW but is one way to at least get to them.
I believe those dates are not visible outside of plans so not pushed to the DW as they are calculated internal values for the plan snapshots.
Having said that I don't know if you have seen the GADO Focal Point-CLM integration? This uses an internal service to pull a couple of details from a plan snapshot. It doesn't go into the DW but is one way to at least get to them.