Zero Suppression using Filter with Tuple

[eliza_jane]

Hi,

We would like to suppress 0's in a cube based report. To suppress this using MDX Filter expression I need to use Tuple function <> 0 as a simple measure <> 0 does not work due to the cube design.

Is using a filter expression involving a tuple beneficial in terms of performance over using the Suppression property available? Wondering if tuple is costlier.

[bdbits]

In my experience it depends on the cube design, number of levels in the category, and how many rows/columns are involved. Column suppression in particular can be a problem, since it has to retrieve all the rows first to determine if the column should be suppressed. In such cases, an expression-based approach will perform much better. While I have not verified it, I would expect an expression will perform at least as well as the built-in suppression since it will reduce the result set.

[tjohnson3050]

This also depends on your Cognos version and cube technology.  In Cognos 10, suppression is able to pass an efficient non empty MDX function with TM1, but SSAS cubes require a configuration change.

[eliza_jane]

Thanks for the input.

We have our reports based against TM1.