AutomaticExceptions Property

Sets or returns whether automatic highlighting of exceptions is on or off.

Syntax

Report.AutomaticExceptions

Applies To

Report Object

Discussion

Use this property to set whether exceptions are automatically highlighted. Automatic exceptions are data driven exceptions (otherwise known as anomalies or outliers). Whenever the crosstab cell values change in a report, the expected value of each cell, based on the row, column, and crosstab totals, is computed and compared to the observed value (the value in the cell). If the difference is significant, the cell value is highlighted as a high (green) or low (red) exception.

This property is only valid when IBM® Cognos® PowerPlay® is in Explorer mode. Otherwise, a message displays indicating that this operation is not available.

Do not use automatic exception highlighting when the row or column is a time dimension.

Default: False

Type

Boolean

Access

Read/Write

Example

This example changes the current setting of the AutomaticExceptions property of the active report. For example, if it is True, it changes to False.

Sub Main()
   Dim objPPRep As Object
   Set objPPRep = GetObject(,"CognosPowerPlay.Report")
   If objPPRep.AutomaticExceptions = True Then
      objPPRep.AutomaticExceptions = False
      Msgbox "Automatic Exceptions highlighting " &
_
         "has been turned off." , , "Automatic Exceptions"
   Else
      objPPRep.AutomaticExceptions = True
      Msgbox "Automatic Exceptions highlighting " &
_
         "has been turned on." , , "Automatic Exceptions"
   End If 
   Set objPPRep = Nothing
End Sub

Related Topics