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.
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.
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.
Thanks for the input.
We have our reports based against TM1.