"An error occurred while executing the query. No changes were made and the previous state is now restored." error is shown when attempting to filter NULL values using the FILTERS option in the Builder tab in SAP Analytics Cloud (SAC)
- SAP Analytics Cloud 2017.23.0
Reproducing the Issue
Log in to SAP Analytics Cloud
- Create a story using a HANA Live Model
- Create a Filter under the FILTERS option in the Builder tab.
- Click the checkbox with the 'NULL' dimension and click Exclude
This issue has been resolved in SAP Analytics Cloud 2017.24.4.
- Help resources and free SAP Analytics Cloud content
- Help portal
- SAP Community (Questions & Answers / Direct Link to ask question / Blogs)
- SAP Community WIKI
- Improvement requests (on the SAP Customer Influence portal)
- Video tutorials
- Videos by topic areas: (Overview, Models and Connections, Stories, SAP Digital Boardroom, Planning, Collaboration, Administration)
- Training events
- Past event recordings
- New user handbook
- How to connect to on-premise data
- 2487011 - What information do I need to provide when opening incidents with SAP Analytics Cloud
- Introducing SAP BusinessObjects Cloud: BI and Planning (SAP Press book)
Your feedback is important to help us improve our knowledge base.
EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Hana Cloud for Planning, EPM-ODS, 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 , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem