Where can I find my custom attribute in the back end?
One answer
Comments
Right now I've got a query subject in Cognos Framework Manager that runs an SQL query on the RTC back end every time it's accessed, which is, in my opinion, the preferred alternative to a scheduled ETL. That post makes it seem like at least I'm able to create a separate object that can be joined on, though ideally I could just add the necessary SQL to my existing query if possible.
From the Introduction of the post: "This document describes how to customize the IBM Rational Insight extract, transform, and load framework (ETL) to extract IBM Rational Team Concert (RTC) custom attributes."
So that post was not about running SQL queries on the RTC back end every time it is accessed, but is about modifying the ETL so that the custom attribute information is added to the data warehouse. Running the query every time the report is run is definitely not the preferred alternative, since that approach will eventually degrade the performance of your server.