COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: gicy on 25 Sep 2008 02:15:57 AM

Title: Drill Through Performance
Post by: gicy on 25 Sep 2008 02:15:57 AM
I have a Total, summary and detail report.

We are providing drill through functionalites to traverse back and forth from Total to summary to detail.

The only issue i have is:

On detail report:

I have a list tab, drill through to go back to summary report,
multiple value prompt, year and month filter plus 4 other filters.

I am providing a PDF and an EXECEL link that will open the detail list reports respectively.

I created a drill through on PDF link to the Detail List report using all the parameters(Six parameters actually). The report opens in a new window in a PDF format satisfying all the condition. No issue at all.

The only issue is : It takes approx. 4 minutes to open a report.
Same thing happens with Excel Link.

This is a performance problem. Can any one suggest me? Is there any workaround or alternate way of doing this.

Please let me know if you need any further information/explanation on this.

Thanks,
Gicy