In RTC for the defect template work item attribute:" description" , where do I find the data item in Rational Insight?

Brandy Guillory (53●1●19●25) | asked Jul 17 '13, 3:05 p.m.
edited Jul 17 '13, 3:09 p.m.

I am trying to build a report in Report Studio and I have all of my data items required except description. I was told it is located in a special location within the comments area but I am not sure where this location is. Any help would be appreciated.

3 answers

Most liked answers ↑|Newest answers|Oldest answers

permanent link

Francesco Chiossi (5.7k●1●10●19) | answered Jul 18 '13, 4:12 a.m.
edited Jul 22 '13, 4:25 a.m.

Hello Brandy,

the work item description field is NOT available in the data warehouse for reporting.

As a reference for the available fields you can check the Change and configuration management data dictionary.

Best Regards
Francesco

Comments

Brandy Guillory commented Jul 19 '13, 4:21 p.m.

Hi Francesco, I see N/A for data warehouse and schema.

Francesco Chiossi commented Jul 22 '13, 4:28 a.m.

Sorry for the confusion, edited my post, I missed the NOT in my answer.
N/A means indeed that is not populated in the data warehouse.

Brandy Guillory commented Jul 22 '13, 12:15 p.m.

Thank you Francesco, you have been very helpful. So if "description" is NOT in data dictionary. Is it located somewhere else? And if not, how can I retrieve this RTC field. Will it have to be mapped?I am not too familiar with mapping but am reading up on this.

Francesco Chiossi commented Jul 26 '13, 11:14 a.m. | edited Jul 26 '13, 11:15 a.m.

Hello Brandy,

it's possible to customize the ETL process in Insight.
See my answer in this topic for some details:

Is it possible to add OOTB fields from RTC to the Rational Data Model?
https://jazz.net/forum/questions/120894/is-it-possible-to-add-ootb-fields-from-rtc-to-the-rational-data-model/121001

permanent link

YOGESH LOKHANDE (104●4●19●27) | answered Jul 22 '13, 8:46 a.m.

Hi Brandy,

I think this link is usefull for you.

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

thanks you

Comments

YOGESH LOKHANDE commented Jul 22 '13, 8:50 a.m.

please check this link

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

0	permanent link Brandy Guillory (53●1●19●25) \| answered Aug 14 '13, 3:39 p.m. this had to be added by SDI team via API

It's all about the answers!

Related questions

In RTC for the defect template work item attribute:" description" , where do I find the data item in Rational Insight?

3 answers

Your answer