Performance tuning of cube reports

[Arumugam]

Hi Team,

         I need to fine tune my report as the performance is very poor.If anyone have documents/suggestions,please share it.It is a cube model

[bdbits]

What have you looked at so far?

For cubes, the first things that come to mind include how many fact tables and dimensions, with how many facts/aggregates and how many members in the dimensions, are you using a crosstab, do you know MDX and can review the generated MDX... and I sincerely hope you are not using detail filters.

[Arumugam]

I am not using detail filters..Slicer is used and lot of conditional block.Will that affect the performance?

[bdbits]

I suppose it is possible if the conditional blocks are dependent upon the results of long-running queries.