SAP Knowledge Base Article - Public

3189201 - Data cannot be merged correctly and consistently when linking two models into a table in SAP Analytics Cloud(SAC)


  • The data cannot be merged correctly and consistently when linking two models into a table in SAC
  • Sometimes the result is expected but sometimes the result is wrong.


  • SAP Analytics Cloud (Enterprise) 2022.02

Reproducing the Issue

  1. Include Model 1 and Model 2 in a story.
  2. Link these two models.
  3. Create a table based on Model 1 and set Model 2 as the link model.
  4. Select link type: all primary data.
  5. Select unlinked dimension options: merge members.
  6. Sometimes, some data cannot be merged but sometimes the same data can be merged in this table.


The issue is caused by a defect in the product.


  • The issue is fixed in a future** version of SAP Analytics Cloud.
  • Please refer to maintenance document.

    ** in version 2022.10. for customers on a bi-weekly (fast track) release cycle.
    ** in 2022 Q3 for customers on a Quarterly release cycle (QRC).

    This Knowledge Base Article, SAP‘s strategy, and possible future developments are subject to change and may be changed by SAP at any time for any reason without notice.
    This document is provided without a warranty of any kind, either express or implied, including but not limited to, the implied warranties of merchantability, fitness for a
    particular purpose, or non-infringement.

    See Also


    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, sap analyst cloud , KBA , LOD-ANA-DES-COR , SAC Core story functionality - widgets, geo, design, etc , Problem


    SAP Analytics Cloud 1.0