SQl Query in Framework Manager

[a.info]

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

[wyconian]

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

[blom0344]

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