If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Tips for improving report performance

Started by mbrent13, 18 May 2023 01:12:12 PM

Previous topic - Next topic

mbrent13

Hi gurus! 

I have a PDF burst to all employees; it contains a lot of data throughout the database so requires approx 30 queries full outer join.  This takes approximately 5-10 minutes per employee, so bursting to all employees will most likely fail.

Is there anything I can check to try to improve the report performance?

bus_pass_man

Hi, I'm not a guru but I used to work with a guy whose name was that.

Read up on ETL.  Hideous messes such as full outer joins and reports with 30 queries strongly suggest that the design of the data warehouse that you are using (assuming that) is somewhat lacking.

It would be better if as much of whatever you are doing is done in the ETL so that there's views etc. in your data warehouse, which have had the bulk of the processing which you are needing already done. 

In addition, since it would be in the data base and not hidden away in a report, it would be available in other reports, which is another aspect of the single version of truth stuff people go on about.