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

Best way to create a Query from a SQL

Started by ale137, 11 Mar 2020 01:58:15 PM

Previous topic - Next topic

ale137

Hello,
Because of issues beyond my control i have to create a report using only queries with SQL. Im not able to properly create a model.
What would be the more performant way to do this, using a single complex query that gives me all the data, or a series of small queries and i do all the data transformations and joins in cognos?

Thanks
Regards

dougp

If...

you have the ability to write your own SQL in Cognos,
and you have good SQL skills,
and you know your database, how it is indexed and partitioned,
and all of the data is available through a single data source connection,

...it is likely that one query that returns exactly what you need will perform faster than having Cognos perform joins and do other work.


But...
It also depends on the requirements for the report.  If you need to use Cognos features like nested objects with master-detail relationships...

Check your requirements.  There is no definitive answer to your question.

MFGF

Quote from: ale137 on 11 Mar 2020 01:58:15 PM
Hello,
Because of issues beyond my control i have to create a report using only queries with SQL. Im not able to properly create a model.
What would be the more performant way to do this, using a single complex query that gives me all the data, or a series of small queries and i do all the data transformations and joins in cognos?

Thanks
Regards

To add to what Doug wrote above, If you are using Query Studio (you posted this question in the Query Studio board) you cannot use SQL directly. You'd need to use Report Studio to be able to do this, and you'd also need the SQL capability granted to you by your Cognos Administrator.

Cheers!

MF.
Meep!