Symptom
- Unable to add rank in a chart in a SAC story.
- Error: "Top-N is not supported in charts with Structures" appears.
Environment
- SAP Analytics Cloud 2.0
- Live BW connection
Reproducing the Issue
- Login to SAC.
- Open a live BW story
- Add one chart.
- Go to context menu.
- Click on Rank.
Notice that it is giving error "Top-N is not supported in charts with Structures"
Cause
This behavior is by design with stories based on live BW model.
Resolution
This is an existing limitation that Ranking is not supported with the BW two structure queries.
Workaround: You can define Top N condition in the backend BW query and use them in SAC. That should work in optimized mode, though classic mode might have some restrictions for BW conditions in Charts.
See Also
- 2788384 - Unsupported Features with SAP BW, SAP S/4HANA and SAP BPC Embedded Model Live Connections in SAC - SAP for Me
- 2527607 Unable to receive system emails from SAP Analytics Cloud (SAC)
- 3522889 SAP Analytics Cloud: Not receiving E-mail Notifications After Activation of Calendar Tasks.
- Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening an case for SAP Analytics Cloud?
- 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
- Search for SAP Analytics Cloud content using Google or Bing:
- https://www.google.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.support.sap.com+SAP+Analytics+Cloud
- https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.support.sap.com+SAP+Analytics+Cloud
- Note: Add relevant text or warning/error messages to the text search field to filter results.
- SAP Analytics Cloud Connection Guide
- Getting Started with SAP Analytics Cloud Expert Community page
- SAP Analytics Cloud Get More Help and SAP Support
- Need More Help? Contact Support or visit the solution finder today!
Keywords
rank, chart, story, SAC, live, bw, model, connection , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem
Product
SAP Analytics Cloud 1.0
SAP Knowledge Base Article - Public