SAP Knowledge Base Article - Public

3366355 - ISNULL Function Does Not Work as Expected for Dimensions and Dimension Properties in SAP Analytics Cloud (SAC)


  • ISNULL() does not work with Dimensions or Dimension Properties in a Calculated Dimension
  • The ISNULL() function will indefinitely return false (even if the input is null)


  • SAP Analytics Cloud 2023.8.18

Reproducing the Issue

  1. Within a Calculated Dimension, apply the ISNULL function to a Dimension or Dimension Property
    • The data must have null/empty cells.
  2. Notice it indefinitely returns False, regardless of if the input is a null/empty value.


  • This issue is under investigation by development.


  • This issue is under investigation by development.


isnull, is null, null, function, formula, calculated dimension,  cd, table, story , KBA , LOD-ANA-DES-CAL , SAC Story Calculations , Bug Filed


SAP Analytics Cloud 1.0