Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

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

Questions
Tags
Users
Badges
Brandy Guillory
(53●1●19●25) 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.

0 votes

3 answers
9,484 views
0 votes

3 answers

Permanent link
Francesco Chiossi
(5.7k●1●11●19) 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

0 votes

Comments
Brandy Guillory
Jul 19 '13, 4:21 p.m.
Hi Francesco, I see N/A for data warehouse and schema.

Francesco Chiossi
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
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
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●20●27) Jul 22 '13, 8:46 a.m.
 Hi Brandy,

I think this link is usefull for you.


thanks you

0 votes

Comments
YOGESH LOKHANDE
Jul 22 '13, 8:50 a.m.
please check this link  https://jazz.net/wiki/bin/view/Main/ReportsDataDictionary 

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

0 votes

Your answer

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

Ask a question
Guidelines
FAQ
Search context
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
× 12,144
× 7,622

Question asked: Jul 17 '13, 3:05 p.m.

Question was seen: 9,484 times

Last updated: Aug 14 '13, 3:39 p.m.

Confirmation Cancel Confirm