It's all about the answers!

Ask a question

Insight schema changes between insight releases, help

sam detweiler (12.5k6195201) | asked Apr 19 '13, 9:14 a.m.
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).

Millard Ellingsworth commented May 20 '13, 6:31 p.m. | edited May 20 '13, 6:31 p.m.

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

sam detweiler commented May 20 '13, 11:17 p.m.

I have not found an answer yet. thanks for asking

Thomas Mathews commented May 21 '13, 11:24 a.m.

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

to upgrade or migrate to?

sam detweiler commented May 21 '13, 11:35 a.m.

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

One answer

permanent link
Thomas Mathews (10614) | answered May 21 '13, 11:23 a.m.
edited May 21 '13, 11:24 a.m.

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.


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.

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:

Please let me know if this information is helpful.


sam detweiler commented May 21 '13, 11:38 a.m.

sorry, you are answering the wrong question

I want to know what changes IBM made to the data schema exported into Insight 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)

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

Jackie Albert commented May 21 '13, 12:07 p.m.

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.

sam detweiler commented May 21 '13, 12:10 p.m.

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.

Your answer

Register or 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.