SAP Knowledge Base Article - Public

3545860 - Unable to Remove Top N Ranking in SAP Analytics Cloud Data Analyzer

Symptom

  • When navigating from an SAC table widget that includes a ranking (such as Top 10) to the Data Analyzer, the ranking is carried over.
  • There is no option to remove this ranking within the Data Analyzer.

Environment

SAP Analytics Cloud

Reproducing the Issue

  1. Open a story that contains a table widget.
  2. Enable the 'Open data analyzer in table' option.
  3. Create a ranking in the table.
  4. Navigate to the Data Analyzer.
  5. Observe that the ranking is also applied in the Data Analyzer and there is no option to remove it.

Cause

The current Table widget in the Story Designer uses an older method for supporting TOP N.

This approach relies on sorting rather than a dedicated filtering mechanism, which is not aligned with the preferred framework for interoperability.

Resolution

Currently, the option to remove the ranking in the Data Analyzer is not available. However, as part of ongoing improvements, TOP N filters created using this older method in Story Tables will no longer be transferred during navigation to the Data Analyzer.

This limitation is recognized, and enhancements are in progress to provide improved functionality. It is recommended to check the SAP Roadmap Explorer for updates regarding new releases for Data Analyzer.

See Also

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, data analyzer, ranking, top n filter, interoperability, table widget, data visualization. , KBA , LOD-ANA-DAN , SAC Data Analyzer , Problem

Product

SAP Analytics Cloud all versions