HANA CompositeProvider (HCPR)
Usage, support and features of the HANA CompositeProvider are discussed. There are two types of Composite Providers(see below), on this page we mainly focus on the new HCPR.
SAP Online Documentation
- BW75 Release: CompositeProvider
- BW/4 Release: CompositeProvider
Composite Provider Types
- HCPR: New Eclipse based HANA Composite Provider created with the BW modeling tools. On this page we mainly focus on this type.
- COPR: Adhoc(Local) Composite Provider created and displayed in transaction RSLIMO/RSLIMOBW.
Analysis / Topics
Check out analysis options and several CompositeProvider topics:
Features/Topics
- HCPR with Non-Unique Joins: Analytic Engine needed
- Review KBA 2118286 for the impact of this issue on performance and memory consumption; see also COPR: Unique Join
- Multiplication of key figures (Non-Unique(Ambiguous) Joins) - read pages 9-18 of the document for a wrong data issue
- HCPR: Handling of Null Values
- HCPR: Setting 'User Confirmed Referential Integrity'
- Authorizations
- Pruning: see Wiki Page Improving BW Query Performance by Pruning and e.g. Example P7
- HCPR & Navigation Attributes
- 0INFOPROV in HCPR
- CompositeProvider based on HANA Model (list of important points to know)
- HCPR: Yellow Request in a Join Node
- Decimal Setting in HCPR on HANA View for Amount Values
- Constants used in HCPR Definition
- HCPR versus MultiProvider
- HCPR with CMP Problem
- HCPR and Calculated Fields(and other Enhancements with BW/4)
Guidelines for Error Analysis
Guided Answers: Troubleshooting BExQueries on HCPR (linked via KBA 2571707 HowTo: Troubleshooting Bex queries on HCPR - decision tree)
SAP Consulting Notes/ SDN Documents at a Glance
Check out if you know all of them (once more available they will be added ):
SAP Notes/ KBA
2271658 Design Considerations for Composite Provider
2800016 BW HCPR - Collective Note for Problems with Queries on HANA CompositeProviders
- 2084937 A Query Built on a Composite Provider/Multiprovider can't be Set as "Query as InfoProvider"
- 2047475 COPR: Multiplication of key figures
- 2118286 COPR/HCPR: High Query Memory Consumption
- 2030944 COPR: Intermediate result set too big for CompositeProviders with BW Accelerator
- 2103032 Long runtime for query on CompositeProvider
- 2372430 Ambiguous Joins: LISTCUBE may display incorrect values
- 2094816 HCPR: Input help in mode D: "Only Values in InfoProvider"
- 1810955 Supported key figures in CompositeProvider
- 2228967 Understanding Automatic Field Assignment in the BW Composite Provider
- 1872746 Model cardinality affects query results
- 2080851 Conversion of MultiProvider to CompositeProvider (program RSO_CONVERT_IPRO_TO_HCPR)
- 2658275 0REQTSN cannot be used in query which is based on HCPR
SDN documents
- SDN Document: What is a CompositeProvider? (COPR)
- SDN Wiki: Common issues