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
Brandy Guillory (5311925) | answered Aug 14 '13, 3:39 p.m.
this had to be added by SDI team via API

permanent link
YOGESH LOKHANDE (10442027) | 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
Francesco Chiossi (5.7k11119) | 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?

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.