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
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 :-)
Quote from: 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
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