debugging a report

[murali]

hi

can anybody tell me how to debug a report and how to use tabular model and tabular sql and some information about queries

and one more thing how multiple queries can be assigned to a page, does multiple queries can affect the performence. any answers will be greatly appericiated.


Thanks
murali

[BIsrik]

firstly you cannot assign multiple queries to a page.

 Multiple queries does affect the performance since all the queries need to be executed while u run the report. If you r executing it in pdf, then make use of tabular reference. This will increase the performance.

 and regarding debugging of a report, usually the data is checked and format required is checked. If both these are proper then, you can think of doing some performance tuning.

Srik

[rvitatoe]

Multiple queries can be assigned to a single page, but they must be in different List or Crosstab Items.

If you are getting an error message that you need to debug, then this site is the BEST place to start!  I have had great success on this site by doing a search for the error message I'm getting.  Not so much on the Cognos support site, but that is definately a second stop.