Using the Advanced Option in Conditional Suppression

The Advanced Option is used to suppress rows or columns in a grid based on specified attributes or values. Conditional suppression can be simple or complex, and can contain a maximum of seven conditions. Advanced conditional suppression can be combined with basic suppression options. See Using the Basic Option in Conditional Suppression.

When you define conditions, you can include the Not operator to suppress rows or columns that do not meet the condition (that result in false), and parenthesis to enclose and separate conditions from other conditions. Conditional suppression may be based on data or formula values.

  To apply conditional suppression:

  1. Create a report, or open an existing report containing a grid.

  2. Select the rows, columns, or grid to which you want to apply suppression.

  3. In the property sheet, click Advanced Options, then click the Setup button to display the Conditional Suppression dialog box.

    Note:

    If you selected a grid, first select the Suppression category in the Grid Properties property sheet.

    Conditional Suppression displays a Basic Options label above the suppression options. Basic options use OR operators:

    • Basic Options:None—Basic options not selected with Advanced options.

    • If Zero, Suppress OR ...—If Zero selected with Advanced options.

    • If Zero OR Missing, Suppress OR ...—IfZero and If Missing selected with Advanced options.

    • If Zero OR Error, Suppress OR ...—If Zero and If Error selected with Advanced options.

    • If Zero OR Missing OR Error, Suppress OR ...—If Zero, If Missing and If Error selected with Advanced options.

    • If Missing, Suppress OR ...If Missing selected with Advanced options.

    • If Missing OR Error, Suppress OR ...If Missing and If Error selected with Advanced options.

    • If Error, Suppress OR ...If Error selected with Advanced options.

      Conditional Suppression Dialog Box

  4. From Suppress Row or Column If, select a property.

    The property selected determines which options are available in the drop-down lists for your expression. The following table lists each property with the default reference, operator, and comparison values. The default values are displayed automatically and can be changed.

    Property

    Data Source Usage

    Data/Formula Value in Cell

    Oracle Essbase

    Financial Management

    Planning Details

    SAP BW

    Data Values in Row

    Oracle Essbase

    Financial Management

    Planning Details

    SAP BW

    Data Values in Column

    Oracle Essbase

    Financial Management

    Planning Details

    SAP BW

    Data Values in Current Row

    Oracle Essbase

    Financial Management

    Planning Details

    SAP BW

    Member Name

    Oracle Essbase

    Financial Management

    Planning Details

    SAP BW

    Description

    Financial Management

    Alias - Default

    Oracle Essbase

    Planning Details

    SAP BW

    Generation

    Oracle Essbase

    Planning Details

    SAP BW

    Level

    Oracle Essbase

    Planning Details

    Account Type

    Oracle Essbase

    Financial Management

    Planning Details

    Auto Calculation

    Oracle Essbase

    Financial Management

    Planning Details

    SAP BW

    Line Item Detail

    Financial Management

    Attribute Value

    Oracle Essbase

    Supporting Detail

    Planning Details

  5. From the Reference Value drop-down list box, select a value corresponding to the property value you selected from the Suppress Row or Column If drop-down list box.

  6. Select one of the following operators, if applicable:

    Note:

    The available operators depend on your property selection.

    • < > (less than or greater than)

    • > (greater than)

    • > = (greater than or equal to)

    • < (less than)

    • < = (less than or equal to)

    • not equals (is not equal to)

    • starts with

    • ends with

    • contains

    • Is

  7. Select one of the following comparison options, if applicable:

    Note:

    The available comparison options depend on your property selection.

    • Number—Enables the assignment of a certain value to a cell.

    • Cell Value—Returns the cell location; for example: A, 3.

    • Row Value—Returns the number of the row.

    • Column Value—Returns the letter of the column.

    • Zero—Assigns zero value for condition.

    • No Data—Indicates no data value for selection.

    • Error—Assigns the condition as an error.

    • string—Enables the definition of a string for the condition.

    • 1, 2, 3,...—Indicates the number of levels or generations in the selected dimension.

    • Non Expense—Assigns the condition as a nonexpense.

    • Expense—Assigns the condition as an expense.

    • True—Assigns a True value to the condition.

  8. To add another condition, click the Add Condition 2 button.

    Note:

    The number on this button is increased to as many as 7 as you add conditions.

  9. To combine the current condition with the following condition, select one of the following operators:

    • Select And if both combined conditions must be met.

    • Select Or if only one of the combined conditions must be met.

  10. Optional: In the Options area, add one of the following logic options to your condition:

    • Select Allow Not to allow suppression only if the condition is not met.

    • Select Allow Parentheses to define precedence, or order of consideration for the conditions, then specify the set of conditions as intended.

  11. To add another condition, click the Add Condition 3 button.

  12. Click OK to return to the grid in your report.

Related Information: