SAP Knowledge Base Article - Public

3215926 - Unable to drill down entities in the query based on Odata API for SAP Successfactors.


Unable to drill down entities in the query based on Odata API for SAP Successfactors.


  • SAP Analytics Cloud (Enterprise) 2022.8.13

Reproducing the Issue

  1. Create a dataset based on SuccessFactors.
  2. Build a new query -> Search for FormHeader. It will be available under PM - Forms Management
  3. Observe that when drilling down from FormHeader -> FormLastContent ->  FormContent, you will get the FormHeader entity list again.
  4. The expected drill down is:


  • Based on the following metadata of the SF Odata service,
    FormContent and formHeader is many-to-one
    FormContent and pmReviewContentDetail is one-to-many
<Association Name="FormContent_asso_FormHeader">
<End Type="SFOData.FormContent" Multiplicity="*" Role="FormContent"/>
<End Type="SFOData.FormHeader" Multiplicity="1" Role="FormHeader"/>
<Association Name="FormContent_asso_FormPMReviewContentDetail">
<End Type="SFOData.FormContent" Multiplicity="1" Role="FormContent"/>
<End Type="SFOData.FormPMReviewContentDetail" Multiplicity="*" Role="FormPMReviewContentDetail"/>
  • As addressed in SAC Help GuideSAC doesn't support  one-to-many navigation. Thus under FormContent, only formHeader is visiable but pmReviewContentDetail is invisiable


This issue is currently a product restriction.


SAP Data Acquisition, Import connection to SuccesFactors, Dataset, OData API, Drill down entities in query, Unable to create query. , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , LOD-ANA-AQU-ODATA , Acquiring Data into SAC using an ODATA connection , Problem


SAP Analytics Cloud 1.0