Composite Provider Problems and Fixes: Few SAP Notes , A Little Help ~

Hi all,

We are on SAP BW7.4 running on SAP HANA.
The SP level was upgraded to SP11 yet issues continued with CP.
I am here sharing few SAP Notes recommended by SAP which are must haves when using Composite Provider.
Hope fully this small list helps in fixing below issues.

But first, the landscape should be enriched with SP level 11 or higher.
But for now..below notes may help any of us..

SAP Note	Decsription
2147414	HCPR: Error in use of navigation attributes
2146207	HCPR: System displays incorrect data for a join characteristic on a LeftOuterJoin
2144863	HCPR: “Inconsistent calculation model/ColumnView < > not found (cannot get cata
2148754	HCPR: Korrekturen für REQTSN Behandlung / InputParameter in gestacktem HCPR
2161625	HCPR: “plan operation failed” when displaying HCPR with unassigned fields
2163945	HCPR: Aggregation instead of MultiProvider node/generation of master data for new values
2166458	Incorrect data/no data for CompositeProvider with join on compound characteristic
2174261	Query on Composite Provider terminates with non-cumulative Keyfigures and Navigation Attributes / 0REQUID_SID
2181672	Failed to find source column *_SID in itab
2185225	Processing of key figures and NULL values from SAP HANA models
2188360	PartProvider cluster statistic information missing when CompositeProvider accessed
2198886	Invalid query;Could not find attribute $$<InfoObject>$$
2205034	Error during creation of V2 view in CompositeProvider activation
2205413	Failed to find source column *_SID in itab
2206397	Termination in CL_RSD_INFOPROV_HCPR_CONSTRUCT _SET_SID_SUPPORT-02-
2209965	Hierarchies are not transferred to the database in a CompositeProvider query
2213427	CL_RSDRV_TREX_HCPR_QUERY does not return NameMapper in layer context in GET_TREX_PARTS
2213428	Termination in CL_RSD_INFOPROV_HCPR_CONSTRUCT _SET_SID_SUPPORT-02-
2219045	Corrections for CompositeProvider check: Compounding, near-line storage
2224454	-CHECK_SELDR1- and ‘NULL value with SID not supported’