Page tree
Skip to end of metadata
Go to start of metadata

As discussed in Improving BW Query Performance by Pruning , pruning can take place in case PartProviders have charcteristics which are set constant.

Simple Example

Our test MultiCube is defined as follows:

  • MultiProvider STPE_MC9 
    • Partcube STPECONST: characteristic ZATSTPEI3 is fixed to the value P01
    • Partcube STPEOLAP1
    • Partcube STPEOLAP2
InfoCube

Table RSDICHAPRO

MultiProvider

Table RSIPRORANGE

Query

The query has a soft filter regarding the characteristic ZATSTPEI3 which is unequal to the constant used in the partprovider STPECONST. Hence, the Analytic Engine can skip (prune) this partprovider:

Transaction RSRT 

When you use the debug function 'Explain MultiProvider' you get information about pruning displayed:

  • No labels