Operations on the result set created by the Analytic Manager are semantic functions that refilter or recalculate the data being displayed without actually changing the original data.
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:
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 Manager and creates the list.
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:
Type |
Type |
---|---|
Axis Operation |
Hiding Nodes with Just One Child |
Grid Operations |
Suppression of Zero Rows and Zero Columns |
Local Calculations |
|
Conditional Totals Suppression (in the Result Row) |
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:
Suppression of Zero Rows and Zero 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.