SAP Knowledge Base Article - Public

3605344 - SAP.GETDATA formula returns - for any node level/parent level member

Symptom

Insering formula SAP.GETDATA to retrieve the value of any node level/parent level member, the formula returns value -. SAP.GETDATA formula works fine for any base level member of the same dimesion.

Environment

SAP Analytics Cloud, add-in for Microsoft Excel

Reproducing the Issue

  1. Insert the data source as a Table
  2. Add SAP.GETDATA formula to retrieve the value of any node level/parent level member.
  3. Get value - as the formula returns.

Cause

Program error

Resolution

Got fixed and deployed in Application Version 2025.9.123.

See Also

3402133 - Formula SAP.GETDATA returns value 0 for an aggregate node when using a data source for formulas

Keywords

node, aggregation node, parent level, 0, -, hierarchy, SAC add-in, SAC Excel Add-in, formula, SAP.GETDATA , KBA , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , LOD-ANA-OF , SAP Analytics Cloud, add-in for Microsoft Office , Problem

Product

SAP Analytics Cloud, add-in for Microsoft Office all versions