It's all about the answers!

Ask a question

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

Brandy Guillory (5311925) | 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

permanent link
Francesco Chiossi (5.7k11019) | 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

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?

permanent link
YOGESH LOKHANDE (10441927) | answered Jul 22 '13, 8:46 a.m.
 Hi Brandy,

I think this link is usefull for you.

thanks you

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

permanent link
Brandy Guillory (5311925) | answered Aug 14 '13, 3:39 p.m.
this had to be added by SDI team via API

Your answer

Register or to post your answer.