2484930 - SPO, Multiprovider, Pruning: Frequent Issues and Questions

Further information is needed on how SPOs or MultiProviders work.

Additionally,  typical issues might occur with SPOs, MultiProviders or with pruning:

Samples:

• When accessing data with given Current date filter - it is unnecessarily hitting historical cube (no BWA) and fetching 0 records.   
• MultiProvider Hint not being used
• Poor runtime of queries
• Entry for MulitProvider in RRKMULTIPROVHINT does not help
• Restricting InfoCube data in MultiProvider does not work
• PartProvider Pruning issues after upgrade
• Performance degraded since InfoProviders not in use are still being read

• SAP NetWeaver
• SAP BW/4HANA

Pruning, multiprovider, SPO, semantic partition, constant, RRKMULTIPROVHINT, buffering, RSR_MULTIPROV_CHECK, logical partitioning, DBMAN 157, Time restriction, time derivation, RSPP_PART_MAINTAIN , KBA , BW-BEX-OT , OLAP Technology , BW-BEX-OT-OLAP , Analyzing Data , BW-BEX-OT-DBIF , Interface to Database , Problem