SAP Knowledge Base Article - Public

3228692 - The top "N" filter on the Stacked Bar/Column chart is not working as expected in SAP Analytics Cloud (SAC)

Symptom

  • After setting the Rank by Top N on a dimension of a Stacked Bar/Column chart in SAC, this chart would not show the Top N values of this dimension but showing the Top N values of the other dimension in this chart
  • Issue happens only when the Version dimension is added into the chart

Environment

  • SAP Analytics Cloud

Reproducing the Issue

  1. Create a Stacked Bar/Column chart containing Measure A, Dimension A in a story in SAC
  2. Select this chart, and select Dimension B into the Color part of the Builder Panel
  3. Set story filters and input control for this chart
  4. Click the 3 dot button beside the chart
  5. Click "Rank", select Dimension A, and click "Top 20"
  6. Observe that this chart would filter out Top 20 values of Dimension B instead of Top 20 values of Dimension A

Cause

  • This issue is the current restriction on the rank feature: there should be no  Version on the chart dimensions. 

Resolution

Possible workarounds:

  • Create a calculated dimension with the value of Version.
  • Add variance to compare different versions.

See Also

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, sap analyst cloud, connected, failure, stopped, sap analyst cloud , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0