Print Page - Performance tuning of cube reports

Title: Performance tuning of cube reports
Post by: Arumugam on 02 Feb 2017 01:05:22 AM

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

Title: Re: Performance tuning of cube reports
Post by: bdbits on 02 Feb 2017 04:00:14 PM

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.

Title: Re: Performance tuning of cube reports
Post by: Arumugam on 02 Feb 2017 11:11:24 PM

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

Title: Re: Performance tuning of cube reports
Post by: bdbits on 06 Feb 2017 10:09:43 AM

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

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Arumugam on 02 Feb 2017 01:05:22 AM