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

Dave Griffin (16●3) | asked 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

One answer

Most liked answers ↑|Newest answers|Oldest answers

permanent link

Kevin Ramer (4.5k●6●177●196) | answered Mar 17 '17, 4:09 p.m.
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.

Comments

Dave Griffin commented 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 commented 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 commented Apr 21 '17, 2:02 p.m.

Kevin,

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

Dave

It's all about the answers!

Related questions

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

One answer

Your answer