QueryProvider or Query as InfoProvider (QPROV)
Usage, support and features of Query as InfoProvider are discussed.
SAP Online Documentation
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
Restrictions
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
Features/Topics
- Packaging and Semantic Grouping in DTP
- QPROV: Example where Query contains non-commutative Formula
- QPROV: Example where Query contains Non-Cumulative (NCUM) Key Figures
- Currency/Unit handling/conversion and InfoSource
- Issue Related to characteristic 0UNIT
- RSDDB: Query as Infoprovider
- QPROV and RSDRI_INFOPROV_READ: check Example
- Query Result saved as CSV File
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.