Report takes too long to load

Hello.
Are all users accessing the same (set of) report(s)? Have you considered
creating a schedule for the report(s) and have people access that latest
version only? You could run your report quite frequently as well, but
the advantage will be that is does not have to be recomputed for every
user connecting.

Hope this helps,
Peter.



On 8/11/2011 9:08 AM, azeleke wrote:

Is there a way to render a report faster when multiple users connected
to the system? When we have one user, the data loads in a reasonable
time but when we have multiple users the page takes up to 45 seconds
to load. Is there an option in Framework manager or Report design
page that can be set to make the rendering faster?

Environment: We have packages that contain max 5 tables. The package
gets the data from a local DB2 table. The tables contain summarized
data (1000 Max). No complex query - just displaying Totals by one of
the fields in a graph and drill down shows detail.

Thank you Peter for your suggestion. We will try that. We have few questions
1) Currently the reports properties are set to run View Most Recent Report. Our end users have read only access to the reports. Correct me if I am wrong: based on the current settings, when the first user runs the report, Cognos will run the report and subsequent users will see the same report since the report option is set to View Most Recent Report. Is that correct? If it is correct, what difference does it make if we schedule the report to run at specified time?

2) In our environment, only the developer has design access to the reports. We are using Reports in dashboard. The dashboard Cognos Viewer applets are configured to display the reports. Is there a performance advantage to use a 'Report View" and schedule the report view to run at specified time instead of scheduling the report directly to run at specified time?

Thank you for your time.

Abe

Hello.
Are all users accessing the same (set of) report(s)? Have you considered
creating a schedule for the report(s) and have people access that latest
version only? You could run your report quite frequently as well, but
the advantage will be that is does not have to be recomputed for every
user connecting.

Hope this helps,
Peter.



On 8/11/2011 9:08 AM, azeleke wrote:

Is there a way to render a report faster when multiple users connected
to the system? When we have one user, the data loads in a reasonable
time but when we have multiple users the page takes up to 45 seconds
to load. Is there an option in Framework manager or Report design
page that can be set to make the rendering faster?

Environment: We have packages that contain max 5 tables. The package
gets the data from a local DB2 table. The tables contain summarized
data (1000 Max). No complex query - just displaying Totals by one of
the fields in a graph and drill down shows detail.

Hello.
I am actually not 100% sure about (1) as all our reports that we ship
always prompt for parameters. But if you have views that have parameters
predefined I would hope that Cognos would automatically save that latest
version. For the scheduled reports in which the parameters are selected
that is the case. People are shown the latest version that was computed
during the scheduled job.

I would just play around with this and see what works for you. Also make
sure to carefully review the online help for Cognos Connections:
http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/topic/com.ibm.swg.im.cognos.ug_cc.8.4.1.doc/ug_cc_i_Reports.html#Reports


For (2): Views are smart pointers to reports that have all their own
properties (such as parameters,languages selected, as well as individual
schedules). So, you can define multiple views on the same report with
each view having different parameters. The online help also provides
more detail on views.

Hope this helps,
Peter.

a) Our top level report pages do not have parameters. They display summary information. The data in the database is summary data (max 250-300 records). From the summary graph, users drill down to detail to see the details. A simple graph report shows on x axis Director name and on y axis # of projects. When only one user accesses the pages, it loads OK and the drill downs display OK but when several users access the pages at the same time, the pages load very slowly (I guess the client side web request sends the request to the server and the server process and send back the html to all user requests at the same time). I am wondering whether Cognos processes the data before the client requests it or not. If it processes it before the request, then the server capability to handle multiple requests could play part in the performance.

b) Does Cognos load the data when displaying dashboard 'Cognos Viewers'? We have about 6 to 7 in one window. Is there a limit to how many Cognos Viewers could be displayed in one dashboard? I could not find documentation on optimal number of Cognos Viewers per dashboard. I was wondering whether having 6-7 viewers in one dashboard negatively affects performance or not.

To improve performance, we are looking to use saved version of each reports including all drill downs. Is it possible to drill down to saved version of the report? The prompt values are saved with the html output. We have main level reports in saved mode and when users click on drill down object, we would like the destination report to open using the parameters supplied by the source report. In short what we are looking is to run the reports including all drilldowns with out accessing the source database (using saved HTMLS from report views). The report views are refreshed based on predefined schedule.