Cognos Analysis Studio vs SSAS2005

[daniele2076]

Hello everybody,
has anyone ever experienced performance degradation using suppress options?

My analysis are ok but, when i suppress Zero/Null on rows/columns my i have to wait several minutes.

thank u,
gm

env:
Cognos Analysis Studio 8.4
MS Analysis Server 2005

[CognosPaul]

I've seen this behaviour. I believe Cognos null/zero suppression pulls all of the members of each level, nests them appropriately and then removes the rows. This is inefficient, try instead to filter each level > 0. This will remove the rows before the suppression, thus making it faster.

Also, in order for AS to work they used a lot of crazy expressions. In my experience it's both easier and faster to simply build the report in RS.

[daniele2076]

It seems faster but...
is there a way to put a "general filter"? When i do analysis i have to edit e reapply my filter anytime to match the current layout (rows/columns)

thank u,
gm