SAP Knowledge Base Article - Public

2496109 - Object values from SAP SuccessFactors queries do not get imported to SAP Analytics Cloud

Symptom

When creating a new model in SAP Analytics Cloud (SAC) from an SAP SuccessFactors (SFSF) data source, some of the values for a specific object are missing.

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

Environment

  • SAP Analytics Cloud
  • SAP SuccessFactors

Reproducing the Issue

  1. Login to SAP Analytics Cloud.
  2. Create new model.
    • "Get data from an app" and select "SuccessFactors".
  3. Select a connection and "Create a new query" or "Use an existing query".
    • In the example, a new query has been created from "JobApplication" table with the following objects: User id, First Name, Referred By, Agency Info
  4. Notice that some/all values are not visible for some of the selected dimensions.

Cause

There is no value specified for the particular entry in the SAP SuccessFactors HCM Suite OData API.

Resolution

  • The behavior is by design.
  • It can be verified by checking the ODataServiceUrl:
    1. Select the Endpoint URL of your SuccessFactors data center.
    2. Retrieve the table, used in SAC using the following link: https://<Endpoint URL of your SuccessFactors data center>/<Table>
      • For Example: https://apisalesdemo4.successfactors.com/odata/v2/JobApplication 
    3. Notice that there is no value (m:null="true") for the same entries which are not visible ion the data integration screen.
      • Data Integration screen:
        SFSF4.jpg
      • Match the values from oData API:
        SFSF3.jpg

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, connecting, conecting, conectando, conexão, modelo, SBOC, SAC, SF, SFSF, Data, Integration, oData , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , How To

Product

SAP Analytics Cloud 1.0