Query Snapshot Index
A query snapshot index (QSI) is the “snapshot” of the query result of a QueryProvider.
You can use QSIs to execute data queries for segmentation a lot faster than when the system has to access the QueryProvider directly.
Features
Generating and deleting QSIs
You generate QSIs in SAP NetWeaver BW, in transaction
RSDDB
. Note that you need to enable the QueryProvider for the generation of QSIs.Non-aggregating key figures in the QueryProvider
If the QueryProvider contains non-aggregating key figures (for example, calculated key figures), you receive a warning message when you create the QSI (“Key figure cannot be post-aggregated”), because this kind of key figure can lead to undesired results in segmentation, in the following cases:
When counting the business partners in a segment
When generating a target group
When displaying the distribution of attribute vales, both in the form of a pie chart or bar chart, as well as in the form of a multidimensional distribution graphic
If the QSI contains such non-aggregating key figures, the system no longer aggregates the data records, even if the other key figures are aggregating. Queries such as “Revenue per Business Partner in Last Quarter”, for which the revenue of individual orders must be aggregated, may therefore not lead to the desired result.
We recommend that you use the description of the attribute to show that a non-aggregating key figure is involved, so that later on in segmentation, you can better reproduce the calculation of results that differ from your expectations.