Symptom
- After setting the Rank by Top N on a dimension of a Stacked Bar/Column chart in SAC, this chart would not show the Top N values of this dimension but showing the Top N values of the other dimension in this chart
- Issue happens only when the Version dimension is added into the chart
Environment
- SAP Analytics Cloud
Reproducing the Issue
- Create a Stacked Bar/Column chart containing Measure A, Dimension A in a story in SAC
- Select this chart, and select Dimension B into the Color part of the Builder Panel
- Set story filters and input control for this chart
- Click the 3 dot button beside the chart
- Click "Rank", select Dimension A, and click "Top 20"
- Observe that this chart would filter out Top 20 values of Dimension B instead of Top 20 values of Dimension A
Cause
- This issue is the current restriction on the rank feature: there should be no Version on the chart dimensions.
Resolution
Possible workarounds:
- Create a calculated dimension with the value of Version.
- Add variance to compare different versions.
See Also
- 2354809 - Failed to call SAP Analytics Cloud agent .. /deploymentInfo error in SAP Analytics Cloud
- 2943656 - When accessing Cloud agent getting: Access to the requested resource has been denied in SAP Analytics Cloud (SAC)
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- 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.ca/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
- https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
- Note: Add relevant text or warning/error messages to the text search field to filter results.
- Getting Started with SAP Analytics Cloud
- Need More Help? Contact Support or visit the solution finder today!
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, sap analyst cloud , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem