SAP Knowledge Base Article - Public

3678067 - Formula SAP.GETDATA not returning values for some account members in Excel Add-in

Symptom

  • Formula SAP.GETDATA is not working correctly for Account members (with LOOKUP formula defined in Modeler).
  • Data Source with same account filter is providing correct values, but when using =SAP.GETDATA(DS_1,[Account],[Member]), the system does not return any values.

Environment

SAP Analytics Cloud, add-in for Microsoft Office

Reproducing the Issue

  1. Open Workbook.
  2. Add formula =SAPD.GETDATA.
  3. Attempt to retrieve data for =SAP.GETDATA(DS_1,[Account],[Member])
  4. "-" is displayed.

Cause

Coding issue.

Resolution

This is resolved with application version 2025.23.212.

See Also

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

Keywords

sap.getdata, account dimension, lookup formula, sap analytics cloud, excel add-in, data retrieval issue, formula error, sap analytics cloud office integration , KBA , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , Problem

Product

SAP Analytics Cloud all versions