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
- Create a story ensuring that there are at least two dimensions of generic and organization types.
- Create a table and include all the necessary measures and dimensions.
- Click on the designer button to open the builder tab and under the filters section, click add filters.
- Click on the bottom option called Advanced Filters.
- Click on the yellow toolbar under Conditions and change the option to And-Exclude when all conditions are satisfied.
- Click on the plus icon and then select dimension.
- After selecting the dimension, set the members of this dimension that you wish to query.
- Click ok to apply the changes.
- 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.
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening an incident for SAP Analytics Cloud?
- 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
- Search for SAP Analytics Cloud content using Google or Bing:
- Note: Add relevant text or warning/error messages to the text search field to filter results.
- SAP Analytics Cloud > Learning > Data Connections
- SAP Analytics Cloud > Learning > Guided Playlists
- SAP Analytics Cloud > Learning > Guided Playlists > Getting Support
- Need More Help? Contact Support or visit the solution finder today!
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