Show TOC

Example: Classification in a QueryLocate this document in the navigation structure

The task is to be able to classify yearly sales by customer in a query.

DataStore Objects and Classification

This is achieved in the following example by creating a DataStore object for direct updates. This object contains all the characteristics - which specify the granularity of the classification - in the key fields (for example, customer, year, version). In this use case, the CLASSIFICATION characteristic has the permitted classifications as master data and is used in the role of key figure. This means that only the permitted characteristic values can be entered at query runtime. The following illustration shows how this DataStore object can be modeled:

Aggregation Level and Classification

An aggregation level is created as an InfoProvider suitable for planning on the DataStore object. This InfoProvider contains the CLASSIFICATION characteristic that is used as a key figure. The following illustration shows how this aggregation level can be modeled.

Defining an Input-Ready Query and Classification

In Query Designer, create an input-ready query with the classification characteristic used a key figure in the columns on the aggregation level. The following illustration shows what this query can look like:

Example: Client with Classification Option

Depending on which client you are using, you can change the classification, for example from value A to a different value (B or C). The following illustration shows what this query can look like after the classification has been changed. Note that if the the classification is consistent, it is entered in the result row. If the classification is not consistent, a special value is entered in the result row (in this case NONEX).