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 (SAC)

Symptom

  • 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).

Environment

  • 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):

    1.png 

  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):

    2.png

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

Cause

  • This is a product limitation.
  • Top N based on a specific context cannot be applied.
  • As in above example, it will find the top 2 Countries, then within it picking up the top 2 states, which is based on the table configuration.

Resolution

Currently, this behaviour is a product limitation.

This feature is not available in the product, however, it may be raised as an Enhancement Request which can be considered in a future release.

To request a new feature or product enhancement, SAP has defined a new process and tool that is now available to customers called Idea Place: https://ideas.sap.com. Idea Place gives customers the ability to log their own Enhancement Requests and work more directly with our Technology and Development group.

SAP is committed to reviewing and responding to the ideas submitted on a regular basis. The ideas with the most votes will receive a higher level of attention for response and consideration. The processes and procedures associated with this site will continue to evolve and enhance over time. Refer to Knowledge Base Article 1515837 for more details.

Refer to below KBA to create enchancement request for SAC.

2424376 - How do you create an enhancement request for SAP Analytics Cloud?

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.

Keywords

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

Product

SAP Analytics Cloud 1.0