SAP Knowledge Base Article - Public

3138063 - SAP Analytics Cloud (SAC) TOP-N functionality only allows at most granular level in a table


In SAC when creating a TOP N it does it on the most granular level. For example if wanting to display the TOP 10 products of the year but then show monthy data, the TOP N becomes TOP 10 per month, which are not necessariy the top 10 of the year.


  • SAP Analytics Cloud (Enterprise) 2022.1.0

Reproducing the Issue

  1. Create a chart with a measure and a Year dimension.
  2. Add a top N to the chart.
  3. Now add a month dimension.
  4. Notice that each month may have different items the TOP N is no longer based on the year.


This is a design limitation of the SAC in that the TOP N is always done at the most granular level in the chart.


  1. You can vote on this as an enhancement to SAC here.
  2. As a work around if it is possible to create the query or view on the database server calculate the TOP N and consume that view in SAC. 

See Also

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


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,,,,,,, predictive analytics (analysis), data analysis (analytics) tools, analytics tools, sap analytics cloud, data literacy, advanced analytics, data democratization, analytics software, real time analytics, self service analytics, advanced data analytics, analytics as a service, analytics cloud / cloud analytics, saas analytics, cloud bi, enterprise planning, cloud data analytics, cloud based analytics, analytics cloud platform, modern analytics, real time analysis, cloud analytics solution(s), what is sap analytics cloud, cloud analytics tools, analytics in the cloud, cloud analytics software , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem


SAP Analytics Cloud 1.0