Suppress8020 Property (Explorer)
Syntax
Report.Suppress8020
Applies To
Discussion
Use this property to refine the focus of a report by identifying categories that are significant contributors to a business measure and by applying rollup to the unimportant ones. You can set this property so that it groups rows and columns that are not meaningful into a single category called Other. 80/20 suppression means that 20 percent of the sample contributes 80 percent of the information. Therefore your view of report data depends on the category population and distribution.
You can suppress less critical items in rows or columns or in both rows and columns. Whatever dimension choice you make, the 80/20 suppression rule applies to all layers in a report. There are four settings for this property:
- 0 (off)
- 1 (on rows only)
- 2 (on columns only)
- 3 (on rows and columns)
It is possible that all categories are significant and there will not be an Other category.
You cannot drill, rank, insert, or delete the Other category. You cannot apply 80/20 suppression when a report dimension includes multiple measures.
You can apply Exception highlighting and select the Other category.
All Other categories along rows, columns, or layers will share the same characteristics, including formatting, name, and hidden state. You cannot apply separate formatting for each Other category in a nested, filtered, or drilled report.
Default: 0
Type
Integer
Access
Read/Write
Example
This example opens a IBM® Cognos® PowerPlay® report and applies the Suppress8020 property to rows and columns.
Sub Main() Dim objPPRep As Object Set objPPRep = CreateObject ("CognosPowerPlay.Report") objPPRep.Open ("C:\Cubes and Reports\Sample1.ppx") objPPRep.ExplorerMode = True objPPRep.Visible = True objPPRep.ShowValuesAs = 2 objPPRep.ShareDimensionLine = 1 objPPRep.Suppress8020 = 3 Set objPPRep = NothingEnd Sub