SAP Knowledge Base Article - Public

3479749 - Changing Result set in Data Preview when using SuccessFactors as source system

Symptom

Creating a Graphical view or SQL View with SuccessFactors as source system shows changing or inconsistent result set in Data Preview

Environment

SAP Datasphere

Reproducing the Issue

  1. Create a SuccessFactors connection
  2. Create a remote table 
  3. Use the table in a Graphical View or SQL view
  4. Preview the data in the target object of the view and it shows changing data. This could happen for a single field or multiple fields based on the view created

Cause

Federated data access using the SuccessFactors ODATA connection uses client side pagination concept that cause inconsistent data retrieval

Resolution

Federated data in SuccessFactors uses client side pagination concept that cause inconsistent data retrieval. This is explained under SAP SuccessFactors Connection help page. As the documentation suggests it is important to replicate the data in to Datasphere to avoid data inconsistencies. 

See Also

Prepare Connectivity for SuccessFactors

Keywords

Datasphere, SF, SuccessFactors, data, inconsistent, changing, Federated, ODATA , KBA , DS-MD-AM , Analytic Model , Problem

Product

SAP Datasphere 1.0