COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: a.info on 07 Nov 2012 04:41:36 am

Title: SQl Query in Framework Manager
Post by: a.info on 07 Nov 2012 04:41:36 am
Hello,

I created a SQL query I want to use in as data source in Framework Manager.
Is it possible and how?

Thank you in advance
Title: Re: SQl Query in Framework Manager
Post by: wyconian on 07 Nov 2012 08:21:21 am
Hi

When you create a query subject choose Data Source (tabkes and columns) and paste your SQL query into the Query Subject Definition window.

Good luck :-)
Title: Re: SQl Query in Framework Manager
Post by: blom0344 on 07 Nov 2012 10:10:52 am
Hello,

I created a SQL query I want to use in as data source in Framework Manager.
Is it possible and how?

Thank you in advance

If you check with options you will find that you can use 3 types of queries:

Cognos
Native
Passthrough

If you can, define a Cognos query subject using existing datasources. Cognos sql also allows for using report parameters for use as query filters. (Which can be VERY helpful is some cases)
Native allows using the full set of supported database functions. The cognos set is quite extensive, but not that well documented within SQL.
Passthrough is the one to skip , there is no parsing before sending it to the DB