SAP Knowledge Base Article - Public

3075766 - Advanced Filters not working correctly with new version of a Planning Model in SAP Analytics Cloud (SAC) & SAP Digital Boardroom


The following advanced filters 'and exclude' applied on a Generic Dimension and an Organization Dimension does not filter correctly in SAP Analytics Cloud (SAC):


  • SAP Analytics Cloud (Enterprise) 2021.14.0

Reproducing the Issue

  1. Create a story ensuring that there are at least two dimensions of generic and organization types.
  2. Create a table and include all the necessary measures and dimensions.
  3. Click on the designer button to open the builder tab and under the filters section, click add filters.
  4. Click on the bottom option called Advanced Filters.
  5. Click on the yellow toolbar under Conditions and change the option to And-Exclude when all conditions are satisfied.
  6. Click on the plus icon and then select dimension.
  7. After selecting the dimension, set the members of this dimension that you wish to query.
  8. Click ok to apply the changes.
  9. Observe that the filters are not excluding the data as expected.


The new Planning Model Version does not have sufficient data-set to apply the filters on.


Populate the newest version of the Planning Model with all the latest data for the advanced filters to query the data-set efficiently.

See Also

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


SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, planning, version, advanced filters, and, exclude , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem


SAP Analytics Cloud 1.0