SAP Knowledge Base Article - Public

2589465 - Error when filtering out NULL values of dimensions within a HANA Live model in SAP Analytics Cloud (SAC) & SAP Digital Boardroom


"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

  1. Log in to SAP Analytics Cloud
  2. Create a story using a HANA Live Model
  3. Create a Filter under the FILTERS option in the Builder tab.
  4. Click the checkbox with the 'NULL' dimension and click Exclude


This issue has been resolved in SAP Analytics Cloud 2017.24.4.

See Also

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


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


SAP Analytics Cloud 1.0