COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: anilkumar on 12 Jan 2010 08:35:38 AM

Title: performance issue
Post by: anilkumar on 12 Jan 2010 08:35:38 AM
Hi

i created MASTER DETAIL Reports using cubes as  DATASOURCES, for running this report its taking 4 hrs in PDF
around  13000  pages.
please any one can help me, how can i increase the performance of this report

i used 5 treeprompts in this report and pagebreaks



Regards
ANIL K.MARRI
Title: Re: performance issue
Post by: MFGF on 12 Jan 2010 08:59:10 AM
If the report is joining multiple cubes in this way, I'm not surprised it is slow.

Is it feasible to point at a single data source containing the relevant data?

MF.
Title: Re: performance issue
Post by: anilkumar on 12 Jan 2010 09:43:03 AM
Hi MFGF


iam using only one cube not multiple cubes.

calculations are more.


Regards
ANIL K.MARRI
Title: Re: performance issue
Post by: MFGF on 12 Jan 2010 09:52:11 AM
Oh, OK.

Why are you having to use master/detail relationships?  Would calculations utilising some of the MDX functions give the same result more efficiently?

Are there any examples you can provide of what you're trying to achieve using the master/detail relationships?

MF.