3538276 - Totals is not hidden by default in Data Analyzer or table

Totals is displaying in data analyzer or table by default even though BW query settings > Show Result Rows is set to "Never".

SAP Analytics Cloud

1. Open Data Analyzer from a chart/table
2. Add a dimension to Rows

When table/chart is created initially it will take BW setting(e.g. Show Result Rows) as the default configuration.
But afterward if we change the backend setting, table/chart will not updated accordingly because SAC stores some meta data of data models (e.g. BW Queries) locally in visualizations and in the story/application.
When changing backend data models, it can occur that this locally stored meta data cannot be properly mapped to the changed meta data in the backend, resulting in errors that can break a visualization or even the whole story/application.
This may also cause issues in the models that could cause them to have to either be rebuilt or even need to be replaced with a new model.

Please recreate the chart/table based on the same BW query and see if the current settings of "Show Result Rows" can be reflected in Data Analyzer report.

2789695 - Considerations when changing backend data models used in SAP Analytics Cloud (SAC)

SAC, data analyzer, table, total, BW query, Show Result Rows, Show Totals Always , KBA , LOD-ANA-DAN , SAC Data Analyzer , LOD-ANA-TAB , Table , Problem