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

Performance issue on Query Studio Reports

Started by ranne_78, 13 Nov 2006 06:01:59 PM

Previous topic - Next topic

ranne_78

We have reports in Query studio.Those reports are in Production now.  When Business user is trying to run those reports those are taking much time i.e nearly 5 or 6 hours even though they are not giving exact and accurate  results. We are getting only piece of data . we are using Alias/Tables in the DB2 Main frame database. For some query items it is not showing data at all.

Can any one help me to get the good performance for Query studio reports.

Thanks.   

MDXpressor

Are you sure that the Query Subjects have properly modelled joins.  Blind Spots and poor performance are often related to incorrect joins in the model.  I can't imagine that you could have created a terribly complex query in Query Studio, so it seems like an infrastructure problem to me.
No, a proof is a proof. What kind of a proof? It's a proof. A proof is a proof, and when you have a good proof, it's because it's proven.

-Jean Chretien