3624007 - The SAC story cannot be displayed due to the large volume of data when using a live connection from Datasphere

• The report fails to load due to the large volume of data when using a live connection from Datasphere. 
• The error message is displayed:
  "The processing in the backend was stopped because of a too high data volume involved in the intermediate calculations.
  To reduce the data volume, check the following options:
  1. Reduce the number of dimensions on the axes.
  2. Reduce the number of exception aggregation dimensions.
  3. Reduce the number of measures/accounts requested.
  4. Add more restrictive filters for dimensions which are on an axis and/or for dimensions which may, directly or indirectly, be used as an exception aggregation dimension."
   

SAP Analytics Cloud 2025.8.13 

1. Log into SAC
2. Open the story > note it is not loading
3. When trying to add a new dimension, it throws the error above
4. If the data is filtered, the story works.

The analytic model being used is quite large and complex. It appears that no views persisted, which caused issues during execution. Specifically, when the model runs, datasphere attempts to handle all views but needs to create intermediate result tables that exceed its capacity.

It is recommended to persist some views to reduce the number of intermediate result tables. This should make the execution process more feasible. Please check the Datasphere Guide: Persisting and Monitoring Views | SAP Help Portal 

• 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 a case for SAP Analytics Cloud?
• 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
• Search for SAP Analytics Cloud content using SAP for Me, Google or Bing:
  • https://me.sap.com/servicessupport/search#?q=SAP%20Analytics%20Cloud%20OR%20SAC&tab=All
  • 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!

SAC, Analytics, Datasphere, large, volume, data, high, error, story, not loading, analytic, model , KBA , LOD-ANA-LDC-HAN , SAC Live Data Connection HANA , Problem