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
- Open Workbook.
- Add formula =SAPD.GETDATA.
- Attempt to retrieve data for =SAP.GETDATA(DS_1,[Account],[Member])
- "-" is displayed.
Cause
Coding issue.
Resolution
This is resolved with application version 2025.23.212.
See Also
- 3079294 - Enhancement Request for SAP Analytics Cloud, add-in for Microsoft Office
- Roadmap SAP Analytics Cloud Add-in for Microsoft Office
- Online help for SAP Analytics Cloud, add-in for Microsoft Office
- SAP Analytics Cloud, add-in for Microsoft Office community topic page
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening an case for SAP Analytics Cloud?
- 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
- Search for SAP Analytics Cloud content using Google or Bing:
- https://www.google.ca/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
- https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
- Note: Add relevant text or warning/error messages to the text search field to filter results.
- SAP Analytics Cloud Connection Guide
- Getting Started with SAP Analytics Cloud Expert Community page
- SAP Analytics Cloud Get More Help and SAP Support
- Need More Help? Contact Support or visit the solution finder today!
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
SAP Knowledge Base Article - Public