Show TOC

Background documentationInterpreting Query Results Locate this document in the navigation structure

 

Before you can even think about interpreting the result of a query on an InfoCube with a non-cumulative key figure, you need to know the sequence of the aggregations.

The OLAP processor executes the aggregations in the following sequence:

  1. Normal aggregation

  2. exception aggregation with respect to the reference characteristic

  3. Currency and units aggregation

    Note Note

    Note: Even in cases where you haven’t included the reference characteristic in the query, an aggregation is implicitly executed using the reference characteristic.

    End of the note.
Example:

Your query has a key figure with the exception aggregation last value (LAS) and the reference characteristic 0CALDAY. You have loaded the following data into your InfoCube:

This graphic is explained in the accompanying text.

You now have the following drilldown by plant in your query:

This graphic is explained in the accompanying text.

This result comes from the fact that the normal aggregation is carried out with respect to the plants. The exception aggregation now has an influence in the construction of the result. As only one value was booked for plant 1 for the last date (16.06), only the value for plant 1 is included in the result, that is, 15.