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

How does Cognos Query Engine process a report?

Started by bonniehsueh, 20 Aug 2008 01:57:15 PM

Previous topic - Next topic

bonniehsueh

How does Cognos process a report? Would like to know the process and sequnece (ie Before the SQL is generated, the generated SQL, to the Cognos Query Engine, to the database and back..and anything else i'm missing)

I'm sure thigns are missing but my first guess is below..
1. Cognos's 'something' references each Page
2. Cognos's 'something' runs Queries in the order of what is referenced on each Page
3. After all pages are processed, a minimized sql is generated and goes 'Once (?)' to the database to pull the data back.
4. Once the data is pulled into Cognos, Cognos's Query Engine displays the members and levels (olap) on the page
  4a. Cognos's Query Engine then calculates Rows in a Crosstab
  4b. Calculates Columns in a Crosstab
5. Cognos's Query Engine then calculates any Totals based on the members and levels already displayed

Am I missing anything..? Sequence?

Thanks in advance