Operations on the result set created by the Analytic Engine are semantic functions that refilter or recalculate the data being displayed without actually changing the original data.
Operations on the result cannot request any data themselves. The OLAP Controller is a layer that allows communication between the Analytic Engine and the front end. It has the task of calling the Analytic Engine, reading data and creating a list that the functions work on. The following graphic illustrates this concept:
Technical Concept
The bottom half of the graphic illustrates the order of the steps in each function:
In the Prepare
step, the function's special requirements are passed to the OLAP Controller as input parameters.
In the Get Data
step, the OLAP Controller reads the data from the Analytic Engine and creates the list.
In the Execute
step, the function is executed on the data provided.
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:
Type | Category |
---|---|
Axis Operation | Hiding Nodes with Just One Child |
Grid Operations | Suppression of Zero Rows and Columns |
Local Calculations | |
Conditional Totals Suppression (in the Result Row) |
If more than one operation is executed on the result set created by the Analytic Engine, 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:
Suppression of Zero Rows and Columns
Hiding Nodes with Just One Child
Local Calculations
Conditional Totals Suppression (in the Result Row)
Operations on the OLAP result set can be called either in Query Designer or directly in the query.