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

Conditional Formatting, Text and Suppression Criteria and Parameters

Conditional Formatting/Text Criteria and Parameters

Type Definition Reference Value Operator Comparison Options
Cell Value Data value (numeric, text or date) in a specified cell Enter the cell reference defined by the column and row (for example, A,1).

For numeric and date types:

  • equals

  • not equals

  • greater than

  • less than

  • greater than or equal to

  • less than or equal to

For textual types:

  • equals

  • not equals

  • starts with

  • ends with

  • contains

  • does not start with

  • does not end with

  • does not contain

Select from one of the following:

  • Value (enter data value)

  • Cell Value (enter cell value: column, row)

  • Row Value (select row number)

  • Column Value (select column number)

  • Zero

  • No Data

  • Error

  • Suppressed
Row Value Data value in a specified row Select row number from a list of rows in the grid.

For numeric and date types:

  • equals

  • not equals

  • greater than

  • less than

  • greater than or equal to

  • less than or equal to

For textual types:

  • equals

  • not equals

  • starts with

  • ends with

  • contains

  • does not start with

  • does not end with

  • does not contain

Select from one of the following:

  • Value (enter data value)

  • Cell Value (enter cell value: column, row)

  • Row Value (select row number)

  • Column Value (select column number)

  • Zero

  • No Data

  • Error

  • Suppressed
Column Value Data value in a specified column Select column number from a list of columns in the grid

For numeric and date types:

  • equals

  • not equals

  • greater than

  • less than

  • greater than or equal to

  • less than or equal to

For textual types:

  • equals

  • not equals

  • starts with

  • ends with

  • contains

  • does not start with

  • does not end with

  • does not contain

Select from one of the following:

  • Value (enter data value)

  • Cell Value (enter cell value: column, row)

  • Row Value (select row number)

  • Column Value (select column number)

  • Zero

  • No Data

  • Error

  • Suppressed
Current Cell Value Data value in the current cell Not applicable

For numeric and date types:

  • equals

  • not equals

  • greater than

  • less than

  • greater than or equal to

  • less than or equal to

For textual types:

  • equals

  • not equals

  • starts with

  • ends with

  • contains

  • does not start with

  • does not end with

  • does not contain

Select from one of the following:

  • Value (enter data value)

  • Cell Value (enter cell value: column, row)

  • Row Value (select row number)

  • Column Value (select column number)

  • Zero

  • No Data

  • Error

  • Suppressed
Member Name Member name that applies to a cell, row or column Select member name’s dimension from a list of dimensions in the model

  • equals

  • not equals

  • starts with

  • ends with

  • contains

  • does not start with

  • does not end with

  • does not contain

 Enter text for member name
Member Alias Member alias that applies to a cell, row or column Select alias table and member alias’ dimension from a list of dimensions in the model

  • equals

  • not equals

  • starts with

  • ends with

  • contains

  • does not start with

  • does not end with

  • does not contain

 Enter text for member alias
Member Name or Alias Either member name or member alias (searches both fields) that applies to a cell, row or column Select alias table and member name or alias' dimension from a list of dimensions in the model

  • equals

  • not equals

  • starts with

  • ends with

  • contains

  • does not start with

  • does not end with

  • does not contain

 Enter text for attribute dimension member name
Member Attribute Associated attribute dimension member that applies to the cell, row or column Select associated attribute dimension from a list of attribute dimensions

  • equals

  • not equals

  • starts with

  • ends with

  • contains

  • does not start with

  • does not end with

  • does not contain

 Enter text for attribute dimension member name
Generation Number Generation number in a specified dimension Select generation from list of generations in the model.

  • equals

  • not equals

  • greater than

  • less than

  • greater than or equal to

  • less than or equal to

 Select a generation number for the specified dimension
Level Number Level number in a specified dimension Select level from list of levels in the model.

  • equals

  • not equals

  • greater than

  • less than

  • greater than or equal to

  • less than or equal to

 Select a level number for the specified dimension
Relative Generation A specified number of generations away in a specified dimension

Note: The relative generation is calculated taking into account all the members of the row or column axis that have conditional format defined.

Select the relative generation number for a specific dimension.

  • equals

  • not equals

  • greater than

  • less than

  • greater than or equal to

  • less than or equal to

 Select a generation number away from the specified dimension
Relative Level A specified number of levels away in a specified dimension

Note: The relative level is calculated taking into account all the members of the row or column axis that have conditional format defined.

Select the relative level number for a specific dimension.

  • equals

  • not equals

  • greater than

  • less than

  • greater than or equal to

  • less than or equal to

 Select a level number away from the specified dimension
Zoom Level Dimension member to zoom into. Not Applicable

  • equals

  • not equals

  • greater than

  • less than

  • greater than or equal to

  • less than or equal to

 Select a zoom level to format for the specified dimension.
Account Type The account type that applies to a cell, row or column Not Applicable

Is

Is Not

Select from one of the following account types:

For EPM Cloud:

  • Revenue

  • Expense

  • Asset

  • Liability

  • Equity

  • Non-Expense

For Essbase, Profitability and Cost Management, and Narrative Reporting:

  • Expense

  • Non-Expense
Position Within First or last row or column of a data segment with multiple members or a member function. Select either Row or Column

Is

Is Not

 Select either Top Row/Column or Bottom Row/Column.
UDA User Defined Attribute (UDA) that applies to a cell, row or column Select dimension with the UDA from a list of dimensions in the model

  • equals

  • not equals

  • starts with

  • ends with

  • contains

  • does not start with

  • does not end with

  • does not contain

 Enter text for UDA name

Conditional Suppression Criteria and Parameters

Type Definition Reference Value Operator Comparison Options
Cell Value

Based on the data type of the specified cell, it can be:

  • Numeric Value

  • Date

  • Smart List

  • Text

 Enter the cell reference defined by the column and row (for example, A,1).

For numeric and date types:

  • equals

  • not equals

  • greater than

  • less than

  • greater than or equal to

  • less than or equal to

For textual types:

  • equals

  • not equals

  • starts with

  • ends with

  • contains

  • does not start with

  • does not end with

  • does not contain

Select from one of the following:

  • Value (enter numeric, text, smart list, or date value)

    Note: Not for Text type.

  • Cell Value (enter cell value: column, row)

  • Row Value (select row number)

  • Column Value (select column number)

  • Zero

  • No Data

  • Error

  • Suppressed
Data Values in Row Data value in a specified row Select row number from a list of rows in the grid

For numeric and date types:

  • equals

  • not equals

  • greater than

  • less than

  • greater than or equal to

  • less than or equal to

For textual types:

  • equals

  • not equals

  • starts with

  • ends with

  • contains

  • does not start with

  • does not end with

  • does not contain

Select from one of the following:

  • Value (enter numeric, text, smart list, or date value)

    Note: Not for Text type.

  • Cell Value (enter cell value: column, row)

  • Row Value (select row number)

  • Column Value (select column number)

  • Zero

  • No Data

  • Error

  • Suppressed
Data Values in Columns Data value in a specified column Select column number from a list of columns in the grid

For numeric and date types:

  • equals

  • not equals

  • greater than

  • less than

  • greater than or equal to

  • less than or equal to

For textual types:

  • equals

  • not equals

  • starts with

  • ends with

  • contains

  • does not start with

  • does not end with

  • does not contain

Select from one of the following:

  • Value (enter numeric, text, smart list, or date value)

    Note: Not for Text type.

  • Cell Value (enter cell value: column, row)

  • Row Value (select row number)

  • Column Value (select column number)

  • Zero

  • No Data

  • Error

  • Suppressed
Data Values in Current Row/Column Data value in a current row or column Not Applicable

For numeric and date types:

  • equals

  • not equals

  • greater than

  • less than

  • greater than or equal to

  • less than or equal to

For textual types:

  • equals

  • not equals

  • starts with

  • ends with

  • contains

  • does not start with

  • does not end with

  • does not contain

Select from one of the following:

  • Value (enter numeric, text, smart list, or date value)

    Note: Not for Text type.

  • Cell Value (enter cell value: column, row)

  • Row Value (select row number)

  • Column Value (select column number)

  • Zero

  • No Data

  • Error

  • Suppressed
Member Name Member name that applies to a cell, row or column Select member name’s dimension from a list of dimensions in the model

  • equals

  • not equals

  • starts with

  • ends with

  • contains

  • does not start with

  • does not end with

  • does not contain

 Enter text for member name
Member Alias Member alias that applies to a cell, row or column Select alias table and member alias' dimension from a list of dimensions in the model

  • equals

  • not equals

  • starts with

  • ends with

  • contains

  • does not start with

  • does not end with

  • does not contain

 Enter text for member dimension
Member Name or Alias Either member name or member alias (searches both fields) that applies to a cell, row or column Select alias table and member name or alias' dimension from a list of dimensions in the model

  • equals

  • not equals

  • starts with

  • ends with

  • contains

  • does not start with

  • does not end with

  • does not contain

 Enter text for member name or alias
Member Attribute Associated attribute dimension member that applies to the cell, row or column Select associated attribute dimension from a list of attribute dimensions

  • equals

  • not equals

  • starts with

  • ends with

  • contains

  • does not start with

  • does not end with

  • does not contain

 Enter text for attribute dimension member name
Generation Number Generation number in a specified dimension Select generation from list of generations in the model.

  • equals

  • not equals

  • greater than

  • less than

  • greater than or equal to

  • less than or equal to

 Select a generation number for the specified dimension
Level Number Level number in a specified dimension Select level from list of generations in the model.

  • equals

  • not equals

  • greater than

  • less than

  • greater than or equal to

  • less than or equal to

 Select a level number for the specified dimension
Zoom Level Dimension member to zoom into. Not Applicable

  • equals

  • not equals

  • greater than

  • less than

  • greater than or equal to

  • less than or equal to

 Select a zoom level to suppress for the specified dimension
Account Type The account type that applies to a cell, row or column Not Applicable

Is

Is Not

Select from one of the following account types:

For EPM Cloud:

  • Revenue

  • Expense

  • Asset

  • Liability

  • Equity

  • Non-Expense

For Essbase, Profitability and Cost Management, and Narrative Reporting:

  • Expense

  • Non-Expense
UDA User Defined Attribute (UDA) that applies to a cell, row or column Select dimension with the UDA from a list of dimensions in the model

  • equals

  • not equals

  • starts with

  • ends with

  • contains

  • does not start with

  • does not end with

  • does not contain

 Enter text for UDA name