It's all about the answers!

Ask a question

Reporting on approvals in RTC user stories


Naweed Jaulim (632732) | asked Nov 05 '13, 3:46 p.m.
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

2 answers



permanent link
Francesco Chiossi (5.7k1819) | answered Nov 06 '13, 5:09 a.m.
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

permanent link
Sumant Renukarya (1.1k23339) | answered Nov 21 '13, 5:38 a.m.
There is this built-in shared query for approvals - 'Pending approvals for me'. Maybe this can be edited to report on approvals on user stories?

https://jazz.net/products/rational-team-concert/features/wi

Your answer


Register or to post your answer.