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

Query defined on Multiprovder which contains one SPO(based on DSO) and one basis DSO(Standard)

The Multiprovider and the SPO is defined as follows

The basis DSO STPE1DSO does not contain the characteristic STPE_C1 (Costcenter) which is used to define the partitions for the SPO!

The query has the following three key figures:

  • Counter: Costcenter 100: Key figure Counter restricted to Costcenter 100 and some materials
  • Counter: Costcenter 100: Key figure Counter restricted to Costcenter 100 and some materials
  • Counter: Partprovider STPE1DSO: Key figure Counter restricted to the partprovider STPE1DSO (basis DSO used in MC)

Since this key figure is not restricted regarding Costcenter the superset of all local selections is empty (so restrictions). Therefore no pruning takes place. Since the provider STPE1DSO does not contain the infoobject Costcenter, it is alo not possible to e.g. define a global filter with Costcenter=100 (since this would exclude this partprovider, see e.g. Example). It is necessary do add the following local filter to the last key figure:

This filter # (not assigned) does not change the data displayed in the query (since all data has Costcenter=#) but leads to the superset ( 100, #) which can be used for pruning. Hence, in this case the partitions 200 and 600 are not queried at all.

 

 

 

  • No labels