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

Features/Topics

• Non-Unique(Ambiguous) Joins: see Ambiguous Joins

• HCPR: Handling of Null Values
• HCPR: Setting 'User Confirmed Referential Integrity'
• Pruning: see Wiki Page Improving BW Query Performance by Pruning and e.g. Example P7
• HCPR & Navigation Attributes
• CompositeProvider based on HANA Model (list of important points to know) 
• Constants used in HCPR Definition
• HCPR versus MultiProvider
• HCPR with CMP Problem
• HCPR and Calculated Fields (and other Enhancements with BW/4)
• 0INFOPROV in HCPR
• HCPR: Yellow Request in a Join Node

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

Check out if you know all of them:

• 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