If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Manipulating generated SQL

Started by renevd, 25 Nov 2008 05:52:25 AM

Previous topic - Next topic

renevd

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

blom0344

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.