SAP Knowledge Base Article - Public

3386232 - Formula Bar Calculated Column Disappears After Applying a Filter in SAP Analytics Cloud (SAC)

Symptom

  • Formula Bar calculated column disappears after applying a Filter.
  • The Filter modifies the original number of columns of the Table, on a Story in SAP Analytics Cloud.

Environment

  • Sap Analytics Cloud 2023.16

Reproducing the Issue

  1. Insert a Table into a Story, in SAP Analytics Cloud.
  2. Create a Formula Bar calculated column based on data in the Table.
  3. Apply a Filter to the table.
    • Note: This can be a Story, Page, or Table filter.
  4. Notice the Formula Bar calculated column disappears.

Cause

  • This issue happens when the filter modifies the number of columns in the Table.
    • This can occur if the filtered subset of data has a column of null values. This would result in Null Suppression removing the column entirely.

Resolution

  • An intended Table may be achievable by disabling Null Suppression and manually filtering undesired (null data populated) members and/or columns.

See Also

Keywords

formula bar, calculated column, filter, disappear, calculated dimension, , KBA , LOD-ANA-DES-CAL , SAC Story Calculations , LOD-ANA-TAB , Table , Problem

Product

SAP Analytics Cloud 1.0