Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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

0 votes



2 answers

Permanent link
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

0 votes


Permanent link
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

0 votes

Your answer

Register or log in to post 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,019

Question asked: Nov 05 '13, 3:46 p.m.

Question was seen: 5,506 times

Last updated: Nov 21 '13, 5:38 a.m.

Confirmation Cancel Confirm