SAP Knowledge Base Article - Public

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


  • In the grid page or grid widget there is an option to filter from the crosstab itself with only a single dimension in the table.
    • If selecting one or multiple rows and clicking the filter button from the context menu the row will be filtered accordingly.
  • After adding more dimensions into the grid, filtering will not be available any more.
  • Filtering will work only from the designer pane but not from the story/grid.


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

Reproducing the Issue

  1. Create a story with a grid widget or a grid page based on Live Data Connection on SAP BW.
  2. Add more then one dimensions as Rows.
  3. Highlight a row and try filtering based on that.


This issue is currently under investigation by Development.


This issue is currently under investigation by Development.

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