SAP Knowledge Base Article - Public

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


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


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


This issue is currently under investigation by development.


This issue is currently under investigation by development.

See Also

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


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


SAP Analytics Cloud 1.0