2652024 - Significant performance decrease when using filters in an SAP Analytics Cloud (SAC) Story

• Story containing one or more tables experience a significant decrease in performance as story or page (input control) filters are added.
• For example, a story may refresh in 30 seconds with 3 filters but will take over 3 minutes if 7 filters are added.

• SAP Analytics Cloud

1. Create a story containing one or more tables. Check performance.
2. Progressively add filters. As filters are added performance will begin to decrease, eventually reaching a significant performance decrease.

Performance decrease is due to the "cascading effect" setting which is on by default in page (input control) filters.

Workaround:

Disable the "cascading effect" on the page (input control) filters.:

• 2511489 - Troubleshooting performance issues in SAP Analytics Cloud *** Master KBA ***
• 2327454 - Low performance occurs in tables / grid and other areas of SAP Analytics Cloud
• 2699872 - How to improve performance in the SAP Analytics Cloud (SAC) app for iOS
• SAP Analytics Cloud Best Practices for Performance
• 2673776 - Restricted measures in the Cross calculations dimension causes poor performance in SAP Analytics Cloud
• 2591655 - Performance analysis when using SAP HANA Live Data Connections in SAP Analytics Cloud *** Master KBA ***
• 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?
• SAP Analytics Cloud > Learning > Guided Playlists
• SAP Analytics Cloud > Learning > Guided Playlists > Getting Support
• Need More Help? Contact Support or visit the solution finder today!

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

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , KBA , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , Problem