Hi ,
Normally the report runs within 40 seconds. but i have used the render variable ( 60 ) . to hide and display the list , prompt ... normally will it affect performance ?
once, i have asked this to cognos consultant, and he said.. it should not affect much..
let me know your findings!!
SQL is usually not generated for non-rendered objects. If the list is a major bottleneck, using a render variable should improve performance significantly. An easy way to confirm would be to either examine the audit logs, or run a trace as the report is running.