With a recent update to our Cognos environment we lost access to the Tools -> Show Generated SQL/MDX option. Anyone have an idea as to where this is managed from. I am able to determine what is ran from database logs but it is time consuming so hoping the group can help me locate where I can reenable this functionality.
Which version are you on now?
If you are in 11 then you should be able to click on the cogwheel on the top right hand corner and choose show generated sql/mdx from the context menu.