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

COGNOS Query Studio - Cannot Find RTC Field - "Filed Against"

Questions
Tags
Users
Badges
Dave Griffin
(16●1●3) Mar 17 '17, 2:55 p.m.

Hey Guys and Gals,

I'm trying to add a column in my RRDI report using query studio. The field I'm trying to find in the RTC "Filed Against" field. In RTC it's populated by entering Work Item Categories.

Can anyone point me in the right direction?

Thanks,

Dave

0 votes

1 answer
2,895 views
0 votes

One answer

Permanent link
Kevin Ramer
(4.5k●9●186●201) edited
Mar 17 '17, 4:17 p.m.

Actually, It's easier than that Request.Category Name
......
Under Operational Data Store / Request Area / Request Category

You'll have do do a join between Request and Request Category.  Use Request.Category ID and Request Category.Request Category ID  columns.


0 votes

Comments
Dave Griffin
Mar 20 '17, 7:26 a.m.

Thanks for the quick response Kevin!

I'm new to RRDI and the query studio, and not sure how to do a Join. Can you please explain how to do that?

Dave 

Kevin Ramer
Mar 20 '17, 8:30 a.m.

Well, I see Category Name on the Requests object in the Operational Data Store, so in this case you don't need a join.

There is a multi-part YouTube series on RRDI one of which is Using Joins


Dave Griffin
Apr 21 '17, 2:02 p.m.

Kevin,

Thanks very much. That info gave me what I needed.

Dave

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,019
× 7,496
× 1,700

Question asked: Mar 17 '17, 2:55 p.m.

Question was seen: 2,895 times

Last updated: Apr 21 '17, 2:02 p.m.

Confirmation Cancel Confirm