SAP Knowledge Base Article - Public

3264828 - A story formula displays the incorrect value in the tables intermittently until it is refreshed

Symptom

  • A story formula(for example, runningsum()) displays the incorrect value intermittently. Once refresh the story, the issue is resolved, till the same issue occurs again.
  • Clear the cache and hard reload of the chrome does not resolve the issue. 

Environment

  • SAP Analytics Cloud (Enterprise) 2022.15.8 

Reproducing the Issue

  1. Open a story which has a story formula.
  2. Notice the value is incorrect. 
  3. Refresh the story. The value for the story formula is displayed correctly. 

Cause

During the investigation, it was identified table widgets containing the calculation was duplicated.  

When duplicating table widgets, the calculation is not copied but shared between tables, which leads to the calculation result being incorrect between tables.

Resolution

By deleting and recreating the calculation, the issue is resolved. The duplicated tables do not share the same calculation any more.

 

Keywords

KBA , LOD-ANA-TAB , Table , Problem

Product

SAP Analytics Cloud all versions