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?
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 Posts
Re: I need help retrieving SQL from an .IMR2013-01-11T16:39:47ZThis is the accepted answer. This is the accepted answer.
- yangling 0600018QDQ
Bobznkazo0 100000BBXF3 Posts
Re: I need help retrieving SQL from an .IMR2013-03-14T23:06:47ZThis is the accepted answer. This is the accepted answer.
- SystemAdmin 110000D4XK