SAP Knowledge Base Article - Public

2584302 - Filters do not get applied correctly in SAP Analytics Cloud

Symptom

  • When using a Live Data Connection to SAP BW, the filters do not get applied properly in SAP Analytics Cloud (SAC).

Environment

  • SAP Analytics Cloud
  • Live Data Connection
  • SAP Business Warehouse

Reproducing the Issue

  1. Logon to SAP Analytics Cloud.
  2. Open a Story where filters should be applied.
  3. Change or apply the filter selection.
  4. Notice that the data is not getting filtered properly.

    1.png

Cause

  • This is a by design behavior. 
  • Selecting a top node will always keep the child node.

Resolution

  • You need to explicitly exclude the child members. 
  • On BW-side you can set the child members to "always hide".

See Also

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

Keywords

Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, connecting, conecting, conectando, conexão, modelo, SBOC, SAC, SAP BusinessObjects Cloud, Business Objects, SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, Filters, Selection, Don't, Set, Available, Members , 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

Product

SAP Analytics Cloud 1.0