SAP Knowledge Base Article - Public

3086377 - "Duplicated navigation property" error appears when import data from an OData service in SAP Analytics Cloud

Symptom

  • While building a query in a dimension for ODATA import connection, when multiple attributes from navigation is selected then generated query is not working.

  • The following error message appears:
    "The following error message comes from the external data service: status: 400 body: duplicated navigation property"

Environment

  • SAP Analytics Cloud (Enterprise) 2021.7.17
  • Import Data Connection to an OData service

Reproducing the Issue

  1. Logon to SAC.
  2. Try to create a model based on OData service. 
  3. Attempt to use multiple navigation attribute from a certain dimension. 
  4. Notice the error message appears upon creation. 

Cause

This issue is currently under investigation by development.

Resolution

This issue is currently under investigation by development.

See Also

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

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0