Insight schema changes between insight releases, help

sam detweiler

(12.5k●6●195●201) 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).

0 votes

Comments

Millard Ellingsworth

FORUM ADMINISTRATOR / JAZZ DEVELOPER 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

May 20 '13, 11:17 p.m.

I have not found an answer yet. thanks for asking

Thomas Mathews

JAZZ DEVELOPER 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

May 21 '13, 11:35 a.m.

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

1 answer

7,314 views

0 votes

One answer

Permanent link

Thomas Mathews

JAZZ DEVELOPER (106●1●4) 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.

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

sam detweiler

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

Jackie Albert

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

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.

2 votes

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.

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

rational-team-concert

× 43,075

configuration

× 6,180

rational-insight

× 1,225

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

Question was seen: 7,314 times

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

Insight schema changes between insight releases, help

Comments

1 answer

7,314 views

0 votes

One answer

Comments

Your answer

Follow this question

Question details

Related questions