Print Page - 8.2 -> 8.4: Performance gone down

Title: 8.2 -> 8.4: Performance gone down
Post by: venkiatmaruthi on 23 Mar 2011 09:20:34 AM

Hi,

I recently upgraded the report from 8.2 to 8.4. It seems working fine. But the performance gone really down. It's taking too long time to show the result.

But in 8.2, it was working fine.

What could be the possible issue?

Title: Re: 8.2 -> 8.4: Performance gone down
Post by: venkiatmaruthi on 25 Mar 2011 04:37:28 AM

any help please....

I treid
PROCESSING : limited local
USE FOR PARAMETER: No
Use local cache: Yes

But no use.

Title: Re: 8.2 -> 8.4: Performance gone down
Post by: PRIT AMRIT on 25 Mar 2011 05:04:35 AM

If it is a simple report, can you redevelop the report and see if the performance is OK? Sometimes it helps though ;)

Title: Re: 8.2 -> 8.4: Performance gone down
Post by: melee on 25 Mar 2011 10:03:09 AM

When validating, do you get any errors or warnings?

Title: Re: 8.2 -> 8.4: Performance gone down
Post by: venkiatmaruthi on 25 Mar 2011 11:21:34 PM

I validated the report but no errors and warnings.

I have 5 lists contains 2 columns. One column as data item and second column having a combination chart.

for 5 lists 5 queries are running.

Title: Re: 8.2 -> 8.4: Performance gone down
Post by: venkiatmaruthi on 31 Mar 2011 01:10:08 AM

After analysis, I found the problem with one query that is having the dataitem as below

maximum([rank] for [Date],[Sales_key])

This for is causing the problem. If I remove this dataitem it works well.

What will be the replacement for this in Cognos 8.4.1?

Title: Re: 8.2 -> 8.4: Performance gone down
Post by: venkiatmaruthi on 14 Apr 2011 08:17:36 AM

Can any one help on this? No way the report is coming on expected time. However, it's good in 8.2.
I redeveloped the report. and also I changed the few aggregation levels as well.

Title: Re: 8.2 -> 8.4: Performance gone down
Post by: techicognos on 24 Jan 2012 10:17:59 AM

Just try calculating max in another query and join between parent and child on Date and Key.. this is just a try.

Title: Re: 8.2 -> 8.4: Performance gone down
Post by: Grim on 24 Jan 2012 10:29:29 AM

Generate the SQL from the 8.2 report, do the same with the upgraded report. Same SQL?

Run the SQL against the DB directly. Same response time?

Title: Re: 8.2 -> 8.4: Performance gone down
Post by: tjohnson3050 on 24 Jan 2012 02:51:47 PM

Are you joining multiple queries in this report?

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: venkiatmaruthi on 23 Mar 2011 09:20:34 AM