Show TOC

Example: Combination of Various OperationsLocate this document in the navigation structure

Use

If you want to perform multiple operations on the result set provided by the analytic manager, the system processes the operations one after the other according to the defines sequence, always continuing with the result from the previous operation:

  1. Suppression of Zero Rows and Zero Columns

  2. Hiding Nodes with Just One Child

  3. Local Calculations

  4. Conditional Totals Suppression (in the Result Row)

The following examples are provided to illustrate certain aspects. In each of these graphics, the query before the operations are performed on the result set is shown at the top, while the query after these operations have been performed is shown at the bottom.

Combination of Hiding Nodes with Just One Child and Suppressing Zero Rows

Figure 1: Example 1

Combination of Conditional Totals Suppression (in the Result Row) and Suppression of Zero Rows

Figure 2: Example 2