Where did my Generate SQL option go?

[wzubke]

Is anyone aware of how a vendor could disable the generate SQL option?  This is a powerful tool for troubleshooting reporting and it would appear the vendor who is providing our canned Cognos reporting does not approve of others reviewing the SQL logic for reporting.  Since we own the data and have full control of the DB i can see no reason to disable this functionality.

Is anyone aware of a permission option somewhere that can be configured to disable/enable the generate SQL options in Cognos 10? We had it in Cognos 8 but lost it with a recent update to 10.

Thanks in advance!

[AnalyticsWithJay]

This would've required some customization in the /webcontent/pat/... files. It's not publicly documented where you could modify this. Unfortunately I don't have time at the moment to dig around in those files.

Some options:

1. If you really want that option back, you could install another instance of Cognos and use free software to run a file compare between the two installs, specifically in the ../webcontent/pat/ folder. When you identify the file, you could create a backup of the existing one and overwrite it.

2. You could enable a DB trace or a Cognos IPF Trace to capture the exact SQL that is being sent to the database.