SAP Knowledge Base Article - Public

2981071 - Not possible to filter null values in SAP Analytics Cloud (SAC)

Symptom

Not possible to filter null values in SAP Analytics Cloud (SAC)

Environment

  • SAP Analytics Cloud (Enterprise) 2020.14.23

Reproducing the Issue

  1. Logon to SAC tenant and create a new model.
  2. Add one measure (measureA) to the model, including values of "1" and "null"
  3. Creating a new story on this model.
  4. Add a cross table to the story, insert one dimension and measureA.
  5. Select Unbooked Data on this dimension.
  6. Create a measure based dimension on measureA.
  7. Set filters on this measure based dimension, it's possible to select "1" or "null" to filter the table.
  8. However, filter on "null" is not working in the table.

Cause

This issue is currently under investigation by development.

Resolution

This issue is currently under investigation by development.

See Also

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

Keywords

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 , KBA , LOD-ANA-DES , Model, Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0