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
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.
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