- How to define custom hierarchy member sorting in SAP Analytics Cloud?
- Only "A-Z" and "Z-A" member sorting is available in Story level in SAP Analytics Cloud.
- Sorting of account members is also unclear.
SAP Analytics Cloud 2017.20.02
Reproducing the Issue
- Logon to SAP Analytics Cloud.
- Open a Story.
- Create a Table.
- Add a hierarchical dimension to the lines/rows.
- Notice that only "A-Z" and "Z-A" ordering available.
Custom formatting can be applied in the model directly.
- Open the model.
- Browse to the hierarchical dimension.
- Select "Preview" (Right upper corner).
- Drag and drop hierarchy members on the "HIERARCHY" panel.
- Save the Model.
- Open the Story and notice that the default order has been changed.
- Same workflow by using drag and drop functionality does also work for account members (measures or key figures)
- Help resources and free SAP Analytics Cloud content
- Help portal
- SAP Community (Questions & Answers / Direct Link to ask question / Blogs)
- SAP Community WIKI
- Improvement requests (on the SAP Customer Influence portal)
- Video tutorials
- Videos by topic areas: (Overview, Models and Connections, Stories, SAP Digital Boardroom, Planning, Collaboration, Administration)
- Training events
- Past event recordings
- New user handbook
- How to connect to on-premise data
- 2487011 - What information do I need to provide when opening incidents with SAP Analytics Cloud
- Introducing SAP BusinessObjects Cloud: BI and Planning (SAP Press book)
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.
CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, connecting, conecting, conectando, conexão, modelo, SBOC, SAC, SAP BusinessObjects Cloud, Business Objects, SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, hier, default, sort, order, preview, drag, drop , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , How To