COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: renevd on 25 Nov 2008 05:52:25 AM

Title: Manipulating generated SQL
Post by: renevd on 25 Nov 2008 05:52:25 AM
I'm using a third party framework .
I want to use an object (a table column) in my report which is not supported by this framework.
Is there a solution for this problem? i.e. adding the column in the generated SQL or ...

I'm a novice with Cognos, so perhaps it's in the manuals, but I cant find it.
If the solution is described in any book or article, please let me know

thanks,

Rene
Title: Re: Manipulating generated SQL
Post by: blom0344 on 25 Nov 2008 07:10:14 AM
You are still authorized to add a data-item to the report and define the exact expression. However, you will need to reference an object from the framework package, but then you have a lot of functions available to create a new 'derived' object. cognos will automatically add this to the query generated.

Simply dragg a data-item from the 'insertable objects' window into an existing query and define the expression you need.