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
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..
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.