SAP Knowledge Base Article - Public

3048595 - Rank Option is greyed out when using a BW connection in SAP Analytics Cloud (SAC)


When using a BW data source, the Rank option is greyed out.



  • SAP Analytics Cloud (Enterprise) 2021.1

Reproducing the Issue

  1. Create a new story based on a BW datasource that contains a hierarchy
  2. Use that Hierarchy in a chart
  3. Try to use the Rank option


This is by design as SAC does not currently support using the Rank option on a BW datasource with a hierarchy.  BW ranking only works when the dimension uses flat representation.


Note: Rank with Hierarchy is support with Hana.


In order to be able to use ranking, you must use a dimension that has flat representation - not a hierarchy representation

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 , KBA , LOD-ANA-DES , Story Design & Visualizations , LOD-ANA-LDC-BW , SAC Live Data Connection BW , Problem


SAP Analytics Cloud 1.0