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

Report performance issue

Started by Hevex, 05 Jul 2010 03:08:18 PM

Previous topic - Next topic

Hevex

Hi All,

Some of our basic Cognos 8.4 reports are running for an hour using a TM1 data source.
While the same report runs within a second if queried on the TM1 datasource itself.
(E.g: Display Top 10 Clients for last year.)

Could you please help to explain what could be the reason for this, and whether there is any way of resolving this performance issue. (e.g would it be possible to pass on a query to TM1?)

Thank you for your help!
Z

blom0344

Such a dramatic difference would point at additional sorting. Perhaps Cognos needs to perform an intensive sort before it can come up with the top 10 clients. My 2 cents for what it is worth..

MFGF

What reporting style has been used in Cognos 8 - relational or dimensional (for example, do the reports use detail filters or MDX expressions to filter the data?)

MF.
Meep!