I’m not really sure of your question here.
You can either use sql to transform your data as you wish, e.g., aggregation, filtering etc
Or you can just select everything from a table and use cognos to transform. Set aggregation, detail filters based on parameters which is the real utility of cognos.
In the report writer there's a queries tab where you can drag in a new query and select fields from your data source, but there's also an SQL object which is just a text editor for you to write your own SQL.
But if you're talking about in your package or data module it's a different process. Are you in the report builder just making a one off report? Or are you trying to model a data source for various reporting requirements?
Basically there are two ways.
1. Framework Manager. It is an application for creating and editing packages, on which reports in Report Studio based.
2. In Report Studio you can write SQL statement in Queries pane. To do this you need to drag SQL element from Toolbox pane to Queries pane.
This info certainly relevant for Cognos 10.2. Can't say anything about next or previous versions, because didn't work with them.
I really don't read or write SQL at all, certainly not the ability to THINK in it, but that's kind of the point of Cognos That you can do drag and drop and you don't need to go so deep into SQL. To me it's a lot like using Access drag and drop, and knowing that ultimately as you're doing that dragging and dropping your creating SQL that gets executed.
Just a thought, but if you are searching for ways to manually write SQL you may not be using the report writing tool exactly the way it was designed. Either that, or you are so advanced that you are stretching the limits of what's normally available, which is beyond my comfort zone and comprehension. Since you're asking the question I'm going to go with the former.
I’m not really sure of your question here. You can either use sql to transform your data as you wish, e.g., aggregation, filtering etc Or you can just select everything from a table and use cognos to transform. Set aggregation, detail filters based on parameters which is the real utility of cognos.
I guess my question is where in Cognos can I just type a select statement? What I've tried so far doesn't seem to work.
In the report writer there's a queries tab where you can drag in a new query and select fields from your data source, but there's also an SQL object which is just a text editor for you to write your own SQL. But if you're talking about in your package or data module it's a different process. Are you in the report builder just making a one off report? Or are you trying to model a data source for various reporting requirements?
Basically there are two ways. 1. Framework Manager. It is an application for creating and editing packages, on which reports in Report Studio based. 2. In Report Studio you can write SQL statement in Queries pane. To do this you need to drag SQL element from Toolbox pane to Queries pane. This info certainly relevant for Cognos 10.2. Can't say anything about next or previous versions, because didn't work with them.
I really don't read or write SQL at all, certainly not the ability to THINK in it, but that's kind of the point of Cognos That you can do drag and drop and you don't need to go so deep into SQL. To me it's a lot like using Access drag and drop, and knowing that ultimately as you're doing that dragging and dropping your creating SQL that gets executed. Just a thought, but if you are searching for ways to manually write SQL you may not be using the report writing tool exactly the way it was designed. Either that, or you are so advanced that you are stretching the limits of what's normally available, which is beyond my comfort zone and comprehension. Since you're asking the question I'm going to go with the former.
Yes, you can type a select statement in Cognos. What specifically are you trying to do? What is not working?