performance issue

[anilkumar]

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

[MFGF]

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.

[anilkumar]

Hi MFGF


iam using only one cube not multiple cubes.

calculations are more.


Regards
ANIL K.MARRI

[MFGF]

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.