3691265 - View Persistency Failure When Using Remote Table based on BW Object as Source - SAP Datasphere

View persistency fails when the view uses a remote table derived from a BW object (e.g., a CompositeProvider – HCPR) as its data source.

The following error message is returned:

{"code":403, "message":"internal error: \"BASE$TEC\".\"$$VIEW_MATERIALIZATION_INSERT_DATA$$\": line 295 col 11 (at pos 11148): Error opening the cursor for the remote database <spaceid.connectionid> [SAP AG][LIBODBCHDB SO][HDBODBC] Base table not found;259 invalid table name: Could not find table/view <HCPR>-FACTVIEW in schema <spaceid>: line 1 col 6919 (at pos 6918) ", "insertingData":true}

SAP Datasphere

View persistency, FACTVIEW , KBA , DS-DI-VIW , View Persistency and Runtime , Problem