13 February 2015

Filter instead of Zero Suppression in IBM Cognos

Sometimes we have simple analysis that returns large amounts of data. As a solution Analysis Studio offers a zero suppression option that excludes all zeros out of the analysis.
When enabled, zero suppression option will start by getting all the data deleting afterword's the unnecessary zeros. The best approach to increase the performance for this functionality would be to internally suppress the zeros, and then retrieve the desired data. As you can imagine using the Analysis Studio zero suppression option when we are retrieving historical data, and several depths across dimensions, will lead to a very poor performance.
The solution would be to filter all the levels for values ≠ 0./p>
Start by choosing the Custom filter option in the rows individual sets:

On the next menu, click on Add a filter line option:

Choose the measure that you want to filter, usually is the default one, set the operator to not equal, 0 as the value, and the For column option leave it as default.  

As mentioned before, and for this to work as expected, all row sets must go into this process. Using the example above, we would also need to do the same for the Sales Organization and Customer Account dimension:  

.

.

.

.

       Rui Sousa
       Consultant