Show TOC

Function documentationSuppress Parameter Locate this document in the navigation structure

 

EvDRE’s Suppress parameter allows you to suppress rows and columns so that no values appear in all fields during an expansion.

Features

You can use the following features with the Suppress parameter:

  • You can base the suppression on a different region of data than the one being retrieved. For example, you may specify that, even if you are retrieving category ACTUAL, you want the suppression to be based on what exists in category BUDGET.

  • You can specify multiple members of the same dimension or different dimensions in the overriding expression. For example, in the Suppress field, you can enter: [actual,budget],2008.total.

  • An alternative suppression method is the block suppression. This feature allows you to activate the suppression but also retain the entire set of members of the innermost expansion, even if only one row (or column) has values.

    You can activate block suppression while defining an alternative region to drive the suppression

  • You can enter the value in any of the expansions defined for the desired axis. The system does not suppress rows or columns returning a zero (where a zero amount is stored in the database). By default, the suppression is driven by the values returned in the data range of the EvDRE function.

Activities

To activate the suppression, enter Y in the Suppress field of an expansion.

To base the suppression on a different region of data, enter the ID of the overriding dimension members in the Suppress field.

To activate the block suppression, enter the keyword B in the Suppress field. This keyword works only in combination with a formatted range of members assigned to the innermost expansion. For example, you can enter SUPPRESS=B:[actual,budget],2008.total.

Retain Members in Suppressions

EvDRE allows you to retain a member in a suppressed dimension. When you select multiple dimensions in the row/column keys, you can display at least one row/column for each member of the outer dimensions, but only the members with values for the inner dimension.

You can use the RETAIN keyword in the SUPPRESS field to retain a member in a suppressed dimension.

You can also use the RETAIN keyword without a parameter. The system takes the member to retain in the suppressed dimension from the current view, as set in the PageKey range.

More Information

EvEXP