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