Our company used to use Cognos to develop reports, but hasn't for several years. I need to retrieve the SQL from some of the existing reports. We don't have a Cognos administrator, nor anyone who knows much about the product. We are running Cognos 7, Version 2.
I can get in to Cognos, and can open a catalog and connect. I can also open .IMR files and run the reports.
My problem is that when I go to Report/Query to get the SQL, "Query" is always disabled, so I can't get at the SQL.
Any ideas as to how I can get at the SQL?
NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.
3 replies Latest Post - 2013-03-14T23:06:47Z by Bobznkazo0
Pinned topic I need help retrieving SQL from an .IMR
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-03-14T23:06:47Z at 2013-03-14T23:06:47Z by Bobznkazo0
yangling 0600018QDQ38 Posts
SystemAdmin 110000D4XK280 PostsACCEPTED ANSWER
Re: I need help retrieving SQL from an .IMR2013-01-11T16:39:47Z in response to yanglingYes, the box is checked. My problem is that "Query" is disabled, so I can't even get to the Query dialog. In the back of my mind, I seem to remember it has something to do with access rights, but I'm not sure.
Bobznkazo0 100000BBXF3 Posts