3713486 - Mismatch number of records on integrating BW based view on SAP Analytics Cloud and SAP Datasphere via OData

In some edge cases on the SAP Datasphere Consumption API while requesting data from SAP Datasphere views which come from non-replicated external BW objects there may be a divergence between the number of the records returned and the number of records informed as total OData count.

This could result into SAP Analytics Cloud and SAP Datasphere integration issue while using OData APIs as communication layer, resulting in truncated imports.

SAP Datasphere 

SAP Analytics Cloud

SAP BW

The resolution for such problem is to temporarily disable the OData Countable capabilities for such views, for this do the following:

1. Edit your view annotations manually adding "@Capabilities.CountRestrictions.Countable": false, in the same level as "elements" under the view name.
2. Deploy your view and try the SAC import again.

With this in place, SAC will not process your import considering the value of @odata.count, which should fix the number of records.

KBA , DS-BB-ODATA , To address issues related to Odata consumption API , Problem

SAP Analytics Cloud all versions ; SAP Datasphere all versions