SAP Knowledge Base Article - Public

2726826 - Unexpected result is shown when performing Linked Analysis between two tables in SAP Analytics Cloud (SAC)

Symptom

  • Unexpected result is shown when performing Linked Analysis between two tables in SAP Analytics Cloud (SAC)

Environment

  • SAP Analytics Cloud 2018.20.2

Reproducing the Issue

  1. Log on to SAC tenant.
  2. Create a story on sample model [BestRunJuice_SampleModel].
  3. Insert the first table with Rows as [Sales Manager] and Columns as [Gross Margin].
  4. Choose the column header of [Gross Margin] and then click Hide column/row from pop-up menu.
  5. Uncheck all items from action menu > Show/Hide.
    => Only all members of dimension [Sales Manager] are shown in the first table and the first row is [Janet Bury].
  6. Insert the second table with Rows as [Store] and Columns as [Gross Margin].
  7. Repeat step 4 & 5 on the second table too.
    => Only all members of dimension [Store are shown in the second table and the first row is [Second Hand].
  8. Open Linked Analysis panel and configure as below:
    => For the first table having [Sales Manager], check Linked item set + This table & Filter on datapoint selection, uncheck Include this item in set.
    => For the second table having [Store], check Linked item set + This table, Filter on datapoint selection and Include this item in set
  9. Choose any value in the first table.
    => The values in the second table will be change accordingly.
  10. Choose any value in the second table.
    => The values in the first table won't be changed, which is expected.
  11. Choose another value in the first table.
    => The first row in the first table having [Sales Manager] will show the model name [BestRunJuice_SampleModel], instead of expected dimension value [Janet Bury].

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, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, table, show, hide, linked analysis, row, header, column, dimension, measure, account , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , Problem

Product

SAP Analytics Cloud 1.0