SAP Knowledge Base Article - Public

2950058 - Unable to set Break Grouping enabled when sorting in custom order in SAP Analytics Cloud (SAC)

Symptom

Unable to set Break Grouping enabled when sorting in custom order in SAP Analytics Cloud (SAC)

Environment

SAP Analytics Cloud (Enterprise) 

Reproducing the Issue

  1. Logon to SAC tenant and create a new story.
  2. Create a new table and insert multiple dimensions and measures to the table.
  3. Select one dimension and right click it.
  4. Select Sort Options and add a new custom order to it.
  5. Find it's not possible to enable Break Grouping.
  6. It's only possible to enable Break Grouping when sorting ascending or descending.

Cause

  • This is a limitation in the product.
  • Custom sort order does not support Break Grouping.

Resolution

  • In the modeler add description to each of the dimension members accordingly, so that A-Z sort with Break Grouping can be used to achieve the desired results.
  • Or add a property to the dimension, and name the property members accordingly, so the same A-Z sort can be used to achieve the desired results.

See Also

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

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 , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0