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

QueryProvider or Query as InfoProvider (QPROV)

Usage, support and features of Query as InfoProvider are discussed.

SAP Online Documentation

Query as InfoProvider

SAP Consulting Notes at a Glance:

Check out if you know all of them:

  • 2046293 BW QPROV: Interesting Facts about 'Query as InfoProvider'
  • 1903468 Formulas in "Query as InfoProvider"
  • 2084937 A Query Built on a Composite Provider/Multiprovider can't be Set as "Query as InfoProvider"
  • 2865773 Query as InfoProvider is not allowed for Queries on CompositeProviders with HANA Models as Part


Find an overview of Bex features ignored or not supported by the QPROV implementation:

  • SAP Online Documentation: Restrictions(BW75)
  • Stock Coverage Key figures are not supported, see note 2572490
  • If the provider contains an transient provider or an aggregation level as a partprovider, the query can't be set as "Query as InfoProvider". See note 2084937.
  • Note, that if the query contains formulas with not clearly defined aggregation behavior(like a constant), an aggregation in the loading process(or later by a query defined on the target provider of the DTP) may lead to unexpected values. See note 1903468 and this example for further details.

To check if a specific query is suitable as QueryProvider you can run the report RSR_QPROV_CHECK in transaction SE38.

Analysis / Topics

Guidelines for Error Analysis


How to find related code corrections

Search notes with key word 'QPROV'. The corresponding application component is BW-BEX-OT-OLAP or BW4-AE-CORE.