SAP Knowledge Base Article - Public

2489336 - Top N functionality returns more dimension members than "N" when using a story which has table SAP Analytics Cloud (BOC)


  • After creating a table in a story which has multiple dimensions assigned and then applying Top N functionality, it returns more dimension members than required in SAP Analytics Cloud (formerly known as SAP BusinessObjects Cloud / BOC).


  • SAP Analytics Cloud

Reproducing the Issue

  1. Logon to SAC. 
  2. Create a story and add a table.
  3. Add a dimension as a row (e.g: Country) and another one as column (e.g: Account):


  4. Apply Top N ranking to this table (e.g: Top 2).
  5. Notice that it works correctly, Top N dimension members are displayed.
  6. Now add another dimension to the rows (e.g: State):


  7. Notice that the Top N ranking returns more rows than expected. (e.g: in case of Top 2, it returns 4 rows).


  • This is a product limitation.
  • Top N based on a specific context cannot be applied.

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.


Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, connecting, conecting, conectando, conexão, modelo, SBOC, SAC, Table, Widget, Story, Top N, Ranking, Dimension, Members, Returns, Shows, Displays , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , Problem


SAP Analytics Cloud 1.0