I have to generate a report against RTC 2.0.0.2 listing stories, approvers, and history; Where in Insight is this data available?
One answer
The out of the box RTC 2.0.0.2 ETL will *not* load the relationship between work item and approver. So if you need to generate that report, you have to customize ETL.
Stories should be stored into RIODS.Request table. You can use Request_Type to filter all stories. History data is available in RIODS.REQUEST_CHANGE_HISTORY. Request_ID in RIODS.REQUEST_CHANGE_HISTORY is the foreign key of RIODS.Request.
Stories should be stored into RIODS.Request table. You can use Request_Type to filter all stories. History data is available in RIODS.REQUEST_CHANGE_HISTORY. Request_ID in RIODS.REQUEST_CHANGE_HISTORY is the foreign key of RIODS.Request.