1. Designing with Reports for Oracle Enterprise Performance Management Cloud
  2. Working with Grids
  3. Working with Conditional Formatting, Text, and Suppression
  4. Working with Advanced Conditions

Working with Advanced Conditions

You can set up multiple conditional expressions to a Conditional Format/Text or Suppression definition and group together expressions as needed.

To add or remove expressions:

  1. Click add button to insert additional expression condition rows.

    Use AND or OR to combine or differentiate the conditions. For example, you can create a condition that tests for data values greater than or equal to 100 AND less than or equal to 1000.

  2. Click remove button to remove an expression condition row.

To add a grouping:

  1. You can use Ctrl-click to select multiple conditions and the conditional operator (AND, OR).

  2. In the Actions menu, select Group expressions.


    In the Actions menu, select Group expressions.

To remove a grouping:

  1. You can use Ctrl-click to select multiple conditions and the conditional operator (AND, OR).

  2. In the Actions menu, select Ungroup expression.


    In the Actions menu, select Ungroup expression.

Example:

The following example illustrates an advanced conditional suppression, with multiple expressions and grouping, using the Narrative Reporting Sample Application.

Example 4-1 Initial Report Design and Preview

The example grid has the Segments and Entities dimensions in the row, each with three selections, and Fiscal Calendar in the columns.


The example grid has the Segments and Entities dimensions in the row, each with three selections, and Fiscal Calendar in the columns.

The previewed result is as follows, with all three Entities appearing for each of the three Segments.


The previewed result is as follows, with all three Entities appearing for each of the three Segments.

Example 4-2 Conditional Suppression Setup

For the conditional suppression, we will suppress the following member combinations:

  • AS > E01

  • DV > E02

The conditional expressions needed to achieve the suppression are as follows:

  • ("Member Name for Segments = AS" AND "Member Name for Entities = E01")

    OR

  • ("Member Name for Segments = DV" AND "Member Name for Entities = E02")

After selecting Row 1 and creating a Conditional Suppression definition, the first two expressions (to suppress the AS > E01 combination) are as follows. Note the conditional operator is AND, so the suppression will be executed when both expressions are true.


Creating a Conditional Suppression definition

Next, you need to add two additional expressions (to suppress the DV > E02 combination). Note the conditional operator separating the last two expressions are AND, and the conditional operator separating the first two and last two expressions are OR.


add two additional expressions

To group the two sets of expressions, the first two expressions and their conditional operator are selected and Group expressions is selected from the Actions menu.


To group, the two sets of expressions

The second set of expressions and their conditional operator are selected and grouped.


The second set of expressions and their conditional operator are selected and grouped.

You can preview the grid result. Note that the two-member combinations (AS > E01, DV > E02) are suppressed from the grid output.


You can preview the grid result.