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

Query based on Multiprovider, report RSPP_PART_MAINTAIN was used to define meta data partitions

Our simple test query is based on a ultiprovider which only contains two infocubes

  • STPE2013: has data until 2013
  • STPE2016: has data from 2014 to 2016

With the help of the report RSPP_PART_MAINTAIN the following entries in the table RSIPRORANGE were generated: 

The query has no global restrictions but two local filters (see Filter Values) regarding the characteristc 0CALYEAR used to define the partitions. One key figure is restricted to the year 2014 and the other one to the year 2015.

We run this query in RSRT and use the debug function Multiprovider Explain in oder to check the pruning

The messages

  • DBMAN 157: 1 InfoProvider(s) excluded because of pruning (filter = STAT)
  • DBMAN 155: InfoProvider STPE2013 excluded because of metadata restrictions

contain some interesting information:

  • One infoprovider was excluded, the name is STPE2013
  • A static/hard restriction was used for pruning

The partprovider(partition) STPE2013 contains only data ou to the year 2013. The query has two local restrictions 2014 and 2015. The system determines the superset of all relevant local restrictions and calculates the intersection with the global hard filter. Since the sample query does not have any global filters the relevant restriction used for pruning is 0CALYEAR=2014,2015. Hence the partprovider STPE2013 isn't accessed at all.

Query with additional unrestricted Key Figure

We use the query from above and add the following key figure 

The key figures is not restricted regarding the reference characteristic0CALYEAR and hence the superset of all local restrictions is empty (no restrictions at all). This means that no pruning can take place.

 

  • No labels