SAP Knowledge Base Article - Public

2658256 - Filtering in a chart based on Live BW query is not available in SAP Analytics Cloud when using multiple dimensions in rows


  • In the chart widget there is an option to filter after highlighting a bar.
    • If selecting one or multiple bars and clicking the filter button from the context menu the chart will be filtered accordingly.
  • After adding more than one dimensions, filtering will not be available any more.
  • Filtering can be done on the designer pane manually in edit mode but not from the story in View mode.


  • SAP Analytics Cloud 2018.10.2
  • Live Data Connection to SAP BW

Reproducing the Issue

  1. Create a story with a chart widget based on Live Data Connection on SAP BW.
  2. Add more then one dimensions.
  3. Highlight a bar or more and try filtering based on that.


Limitation on BW backend side.


Fix has been shipped on BW 7.50 SP16.

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.


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 , SAP Analytics Cloud (SAC) , 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