Hi Guys,
Ã, Ã, Ã, Ã, Ã, Ã, Ã, I am pretty new to COGNOS and am working with Report Studio. I want to know how do you write user generated queries in report Studio for generating a report. I dont want to use the SQL generated by COGNOS. I would highly appreciative if you could solve my doubt.
Are you are talking about using your own SQL? Select 'Queries' from the 'Query Explorer', such that you can see all of the queries in your report, if any. This should open up the Insertable Objects window on the left side. Simply drag over the item named SQL and the rest should be clear. Open the new SQL node it placed on the sheet and type in your SQL.
Take a look at the new Union capability as well, it's pretty slick.
Good Luck.
t.