Report Slowness

[Rency]

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 .

[CognosPaul]

Instead of using suppression, try changing your data item to something like:

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