Cognos Analytics 11.1.7
Microsoft Windows 2016 server
Can i store the Native SQL query the users send to the database for later troubleshooting?
Activate logging of the SQL query to the AUDIT database.
Setup the AUDIT database logging in Cognos Configuration.
Browse to Cognos Analytics (ibmcognos) and go to Manage > Administrative Console > Configuration > Dispatchers and Services. Click on the Set Properties – Configuration icon.
Click the Settings tab, choose logging as category.
Go down to Generate comments in native SQL and mark it.
Run some reports to test the system.
Open SQL Developer and go to your AUDIT database and check the