SAP Knowledge Base Article - Public

2892544 - Sorting gets disabled after deleting or changing filter in SAP Analytics Cloud (SAC)

Symptom

The following behavior occurs when visualizing a higher amount of data-points in a chart in SAP Analytics Cloud (SAC):

  1. The default/custom sorting based on dimension get changed.
  2. Not all the data-points can be displayed.

Environment

SAP Analytics Cloud (Enterprise) 2019.21.8

Reproducing the Issue

  1. Logon to SAC tenant.
  2. Create a story.
  3. Add a chart with a measure and dimension with a high number of dimension members.
  4. Restrict the available dimension members with a Filter or Input control.
  5. Apply any kind of sorting on the chart based on the dimension.
  6. Delete the applied Filter or Input control.
  7. Notice that Auto Top N sorting is applied and sorting option gets disabled.

Cause

  • The behavior is by design.
  • Charts with too many data-points will trigger an 'Auto Top N'. This is intended to protect the chart from overplotting and poor performance.

Resolution

  • When an Auto Top N is applied sorting is disabled. The Auto Top N is effectively a sort on the measure value and we don't support multi-measure sorting today.
  • Limits for different chart types:
    • Radar: 100
    • Bar/Column/Line: 500
    • Pie/Donut: 10

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, greyed out, grayed out, input control, Auto Top N , KBA , LOD-ANA-DES , Model, Story Design & Visualizations , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , Problem

Product

SAP Analytics Cloud 1.0