I would suggest that you use anything (that's ANYTHING) other than the Cognos Script Editor to debug your macro.
If you have it you can use Visual Basic (6.0 works fine and is 100% compatible). Failing that create a macro in MS-Excel and cut and paste your script into it.
The reason you are...
Or, if you really want control over what is sent to be processed then you can edit the SQL directly and then save it. This way you can add hints etc. but you lose some of the drag and drop functionality of a normal report.
The best way to do this is to write a report and get it pretty much how...
Change to the Profile tab and click on the SQL radio button. Then hold down Left-Shift, Left-Ctrl and Left-Alt all at the same time and left click the Edit button.
This will take you into the "Magic Query" window where you will see what the "true" SQL is, i.e. what is going to be passed to the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.