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

Insight schema changes between insight releases, help

as we start to expand our reporting using Insight, we are discovering we need some additional data.. where can I see the list of additional data added to the rtc and Insight warehouses by the different releases

specifically at the moment we need 4 things

1. the project teams and team members
2. the iteration hierarchy that clearly defines 'release', (as compared the the 'has a release' checkbox which is needed to display execution items in  plan views. (so this flag is checked on for every iteration).

0 votes

Comments

Hi, Sam. Did you still need assistance with this? If not, can you please tell us what you found out? 

I have not found an answer yet. thanks for asking

What version of Insight and RTC are you currently using and what are your plans

to upgrade or migrate to?

sorry, we are at 1.11 ( RTC 3.0.1.1)
and going to 1.1.1.1 (RTC 4.0.1)



One answer

Permanent link

Hello Sam,

Rational Insight can report on any of the data from RTC as long as it's exposed

via its XML data source adapter, if this data is not exposed from RTC then it

may not be possible to report against specific data.


RTC REST API

https://jazz.net/wiki/bin/view/Main/ReportsRESTAPI

Another good source of information regarding to the changes to RTC or other CLM applications are also included in there respective product release notes too.

https://jazzweb1.torolab.ibm.com/downloads/rational-team-concert/releases/4.0.2?p=releaseNotes

Most of the changes for Insight can be reviewed in the release notes for each

version of Insight. Due to the customization of the Insight Data Warehouse

customer can also add tables to the Insight data warehouse as well to match

your business unit needs.

This link below is also a Fix list for Rational Insight by version:

http://www-01.ibm.com/support/docview.wss?uid=swg27023620

Please let me know if this information is helpful.

 

0 votes

Comments

sorry, you are answering the wrong question

I want to know what changes IBM made to the data schema exported into Insight 1.1.1.1 with RTC 4.0.1..

we are expecting

1. project release and iteration data and hierarchies.
2. some additional data on workitem links (type and target workitem)
and???

I want to find the documentation on what additional data in in the warehouse as provided by IBM.

Only way I know of doing this is to go read the "Release Notes" and "New and Noteworthy" sections for each release.  Also,  besides reading the Insight section you'll need to go through each of the CLM products to see what they've added too since some pieces come from the Insight team and others come from each product team.

Not a great answer, I know, but it's the only way I've found of gathering the data.

I know.. sometimes the data u need is not in those two sources..

I think it is the responsibility of the provider to document the changes/enhancements in a consumable, value descriptive way.  vs all of us having to dredge thru the limited content ourselves.

2 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
× 6,126

Question asked: Apr 19 '13, 9:14 a.m.

Question was seen: 5,427 times

Last updated: May 21 '13, 12:10 p.m.

Confirmation Cancel Confirm