SAP Knowledge Base Article - Public

3338093 - Data in table is not loaded correctly on a specific story page based on SAP BW live connection in SAP Analytics Cloud (SAC)

Symptom

  • Data in table is not loaded correctly on a specific story page based on SAP BW live connection

 

Environment

  • SAP Analytics Cloud (Enterprise) 2023.8 (SAC)

Reproducing the Issue

  1. Open the story
  2. Go to the problem page, note that data is not correctly loaded in the table
  3. Duplicate the page, correct data shows

Cause

  • The table shows different data because a linked analysis filter is applied on it. If the linked analysis filter is removed from the table it shows expected data.
  • It seems that at one point a linked analysis filter was created on the source widget and then the measures and dimensions were removed from the source widge after.
  • Once created on a target widget a linked analysis filter is not removed unless the source widget is deleted, or the filter is explicitly removed from the target widget.
    Note if the Filters section is not visible on a table it can be made visible by selecting the table click ... on the right upper corner, and select Show/Hide table values.

Resolution

  • Delete the linked analysis filter filter or copying the target widget on to another page also effectively removes the filter because the scope of the “Linked Analysis” definition is only the original page it was created on.

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, Model, BW, Connect, Story, Tenant, live, Failed, Using, Working, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, wrong, unexpected, copy , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0