It's all about the answers!

Ask a question

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


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



permanent link
Kevin Ramer (4.2k6147168) | 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

Your answer


Register or to post your answer.