Show TOC

Example documentationExample: Combination of Various Operations Locate this document in the navigation structure

 

If you want to perform multiple operations on the result set provided by the Analytic Engine, 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 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

This graphic is explained in the accompanying text.

Example 1

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

This graphic is explained in the accompanying text.

Example 2