SAP Knowledge Base Article - Public

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

Reproducing the Issue

  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.



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


See Also

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


SAP Analytics Cloud 1.0