COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Rency on 10 Jun 2013 01:18:04 PM

Title: Report Slowness
Post by: Rency on 10 Jun 2013 01:18:04 PM
Hi  Tech Experts ,

I am working on Cognos Reports ,  facing report slowness on mutlidimensional cross tab reports  which using FM Model (DMR ) .

if i suppress null rows and columns takes minutes to give values with out suppression report is faster ,but i need to cleanse the data before showing to customer .
Title: Re: Report Slowness
Post by: CognosPaul on 10 Jun 2013 01:33:44 PM
Instead of using suppression, try changing your data item to something like:

filter([Cube].[Dim].[Hier].[Level],[Measure] is not null)