Suppress Values

You can ignore categories whose values fall into a low range. For example, sales channels that are not active contributors to the bottom line are better left out of the report. You can also ignore categories that either do not apply to the report or that return zero values.

Note: All the suppression buttons remain enabled until you click them again.

Apply Zero Suppression

Zero suppression removes rows or columns containing all zeros, missing values, overflow values, or the results of dividing by zero. You can do this for rows, columns, or both. Zero suppression only applies to the first measure.

When you apply zero suppression to a chart that supports multiple measures, the suppression is only applied to the first measure. You cannot apply suppression to a second measure, such as the line of a correlation chart, or to conditions when both measures are zero.

The Explain window includes information about your selected zero suppression options, and any PowerPlay Web URLs created by the Prepare Bookmark command retain your changed settings, provided zero suppression was enabled for the crosstab.

The Rows/Columns Only setting saved with your Web report applies when running in Windows. However, if you open a Web report in PowerPlay using the Run report in Windows command, your PowerPlay for Windows Preferences will override any zero suppression options set on the Web.

If you want to retain your changed settings after you return from a drill-through report or cube, remember to use the Return to Source command. Any other navigation method will cause your changes to be lost, and your report will revert to the default zero suppression settings.

Note: Enabling zero-suppression can impact performance.

Steps

1. On the PowerPlay Web toolbar, click the Zero Suppression Options button .
2. If you do not want suppression to be performed on both rows and columns, click Rows Only or Columns Only, and click Options.

Note: If these actions are disabled, contact your administrator. The PowerPlay Enterprise Server Administration tool can be used to enable or disable the setting of zero suppression options.

3. To disable a particular zero suppression option, clear the selection check box. By default, the following suppression check boxes are selected:
   • Zero values
   • Divide by zero
   • Missing values
   • Overflow values
4. Click OK to save and apply your changes to the current PowerPlay Web browser session.

Apply 80/20 Suppression

80/20 suppression removes rows or columns whose absolute values do not contribute to the top 80% of results. It then summarizes the removed rows or columns into a single row or column named Other.

When you apply 80/20 suppression, the data for the cells is sorted in descending order and a total is made of the absolute values. Then the sorted values are added until the cumulative total is 80%t of the total. If the last value added to the cumulative total appears in more than one cell, all those cells are considered part of the 80%.

In Microsoft SQL Server Analysis Services cubes, if the dynamic rollup of the Other category includes a category that is also filtered as a result of the overall 80/20 suppression, a conflict results that causes PowerPlay Web to return an NA value for the Other category.

Step

• On the PowerPlay Web toolbar, click the 80/20 Suppression button .

PowerPlay Web shows the total of values suppressed in an additional row or column named Other and shows 80/20 suppression at the bottom of the report page. If a category labeled Other is not shown, all the categories in the report dimension contribute to 80% of the total.