SAP Knowledge Base Article - Public

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

Symptom

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

Environment

  • 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:
    FormHeader->formLastContent->FormContent->pmReviewContentDetail->FormCompetencySection.

Cause

  • 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>
 
<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

Resolution

This issue is currently a product restriction.

Keywords

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

Product

SAP Analytics Cloud 1.0