SAP Knowledge Base Article - Public

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

Symptom

  • 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)

Environment

  • 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.

Cause

  • This issue is under investigation by development.

Resolution

  • This issue is under investigation by development.

Keywords

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

Product

SAP Analytics Cloud 1.0