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
- Insert the data source as a Table
- Add SAP.GETDATA formula to retrieve the value of any node level/parent level member.
- 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