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
- Insert a Table into a Story, in SAP Analytics Cloud.
- Create a Formula Bar calculated column based on data in the Table.
- Apply a Filter to the table.
- Note: This can be a Story, Page, or Table filter.
- 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