SAP Knowledge Base Article - Public

2809265 - Linking based on ID does not work properly in SAP Analytics Cloud

Symptom

  • When linking the dimensions based on ID, the data is not displayed correctly in SAP Analytics Cloud (SAC).
  • For one table it shows the data correctly but for the other it returns with "No value".

Environment

SAP Analytics Cloud 2019.10.6

Reproducing the Issue

  1. Logon to SAC. 
  2. Open a Story. 
  3. Set-up linking using the "Link Dimensions" option.
  4. Link the dimensions by ID.
  5. Notice that the linking does not work properly and one of the widget returns "No value". 

Cause

  • All of the dimension from one of the model has trailing space in their Member ID. 
  • Because of this mismatch between Member IDs, the table blend cannot produce any matches and displays the "No value" message. 

Resolution

The issue can be resolved by fixing these mismatches between the Member IDs.

See Also

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

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, Linking, dimension, model, ID, display, show, value, mismatch, , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , Problem

Product

SAP Analytics Cloud 1.0