Cognos 10 adhoc report response time is very high

[ashvinimrao]

Hi there,

we are testing an adhoc report both in Cognos 8 and Cognos 10 environments. ( We are migrating the report from C-8 to C-10 environment)

The Cognos 8 report comes up in less than 5 minutes where as the Cognos 10 report is very slow and the rendering time is very high.
What could be the reason and how to fix it?

Please note that the prompt values used in C-8 and C-10 are the same.

[BigChris]

Hi - have you checked to make sure that the SQL is the same both reports? If they're different have you tried running the SQL directly on your database to see if you get slow responses there as well?

[ashvinimrao]

Thanks  for the reply, I found that the issue was with the C-10 report, some of the function like in_range are not supported in C-10 so I had to rewrite the logic.
The C-10 report instead of showing an error ran for a long time and hung up.

[bdbits]

in_range is a valid operator in Cognos 10.

It sounds like you got things working for you, but for the benefit of others who may read this thread I wanted to note this. Not sure why it was not working for you.