2496109 - Object values from SuccessFactors queries don't get imported to SAP Analytics Cloud (BOC)

SAP Knowledge Base Article - Public

2496109 - Object values from SuccessFactors queries don't get imported to SAP Analytics Cloud (BOC)

Symptom

When creating a new model from SuccessFactors application, it seems that some of the values for a specific object are missing. For Example:

SFSF1.jpg

Environment

  • SAP Analytics Cloud 2017.11.2
  • 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:
      SFSF2.jpg
  4. Notice that some/all values are not visible for some of the selected dimensions.
    SFSF1.jpg

Cause

There is no vaue specified for the particular entry in the 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.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

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 , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , How To

Product

SAP Analytics Cloud 1.0