Operations on the Result Set

Concept

Operations on the result cannot request any data themselves. The OLAP Controller is a layer that allows communication between the Analytic Manager and the front end. It has the task of calling the Analytic Manager, reading data and creating a list that the functions work on. The following graphic illustrates this concept:

Figure 1: Technical Concept

The bottom half of the graphic illustrates the order of the steps in each function:

1. In the Prepare step, the function's special requirements are passed to the OLAP Controller as input parameters.

2. In the Get Data step, the OLAP Controller reads the data from the Analytic Manager and creates the list.

3. In the Execute step, the function is executed on the data provided.

Types

There are two types of operations on the result set:

Axis operations work on the data in an axis (row or column axis). These are read in a data request.

Grid operations work on the entire result set of all data requests. This includes both axes.

The following operations have been implemented:

Order of Execution

If more than one operation is executed on the result set created by the Analytic Manager, the system works in a given order. It is important to follow this, as every operation builds on the result of the preceding one. The system executes the operations as follows:

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)