Reporting on approvals in RTC user stories
Hi,
I am looking for the best possible option to be able to report on approvals(approval tab) on a user story in RTC.
Is this data exposed in the datawarehouse and how I can report from it using Insight?
If not exposed, can this be queried directly with associated best practices against the CCM database?
Thanks,
Naweed
I am looking for the best possible option to be able to report on approvals(approval tab) on a user story in RTC.
Is this data exposed in the datawarehouse and how I can report from it using Insight?
If not exposed, can this be queried directly with associated best practices against the CCM database?
Thanks,
Naweed
2 answers
Hello Naweed,
Approvals and approval descriptors information has been added to the data warehouse and the data model in RTC 4.0.3.
See the "ETL for approvals and approval descriptors" section of the Rational Team Concert 4.0.3 New & Noteworthy document for reference:
https://jazz.net/downloads/rational-team-concert/releases/4.0.3?p=news#etl-approvals
In the data model they are available under:
Operational Data Store > Request Area > Request Approval
Operational Data Store > Request Area > Request Approval Descriptor
Operational Data Store > Request Area > Request Approval State
Operational Data Store > Request Area > Request Approval Type
For reference on the data model see:
Change and configuration management data dictionary
http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m4/topic/com.ibm.team.reports.doc/topics/ccm-roles.html
In general we don't support and recommend any direct access to the data in the application repository database.
Best Regards
Francesco
Approvals and approval descriptors information has been added to the data warehouse and the data model in RTC 4.0.3.
See the "ETL for approvals and approval descriptors" section of the Rational Team Concert 4.0.3 New & Noteworthy document for reference:
https://jazz.net/downloads/rational-team-concert/releases/4.0.3?p=news#etl-approvals
In the data model they are available under:
Operational Data Store > Request Area > Request Approval
Operational Data Store > Request Area > Request Approval Descriptor
Operational Data Store > Request Area > Request Approval State
Operational Data Store > Request Area > Request Approval Type
For reference on the data model see:
Change and configuration management data dictionary
http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m4/topic/com.ibm.team.reports.doc/topics/ccm-roles.html
In general we don't support and recommend any direct access to the data in the application repository database.
Best Regards
Francesco