Symptom
- In Planning mode, where there are two different inputs to be processed :
1. from SAC table
2. from the SAP.SETDATA formula - After entering input data in table and proceed "Process Data", the SAP.SETDATA values are ignored at the first "Process Data", and the only processed value are the one coming from the table.
- In order to take into account values calculated from SAP.SETDATA formula, a second "Process Data" is needed so that new values coming from SET.SETDATA formulas are considered and processed.
Environment
- SAP Analytics Cloud SAC Excel Add-in - Add-in Version 1.23.0.2 - Application Version 2026.9.188
Resolution
- The behavior observed (the first Process Data for values entered manually, and second Process Data for values entered with SAP.SETDATA formulas) is current product design behavior.
Refer to the user Guide for SAP.SETDATA | SAP Help Portal (https://help.sap.com/docs/SAP_ANALYTICS_CLOUD_OFFICE/29624d6020b74bf8817bb7df398e5cb6/a2c62b981387463abb192deeae4efc65.html?q=SAP.SETDATA) where we can read for the section " Behavior when entering planning values with an SAP.SETDATA formula:" - When you enter new values with the formula and manually in your workbook and choose Process Data, only the values entered manually are submitted to the database at first.
Once this step is completed, the Process Data option is still enabled, and you can choose it to submit the values entered with the formula like SAP.SETDATA.
See Also
- KBA 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- KBA 2487011 - What information do I need to provide when opening a case for SAP Analytics Cloud?
- KBA 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
- SAP Analytics Cloud Connection Guide
- SAP Analytics Cloud Get More Help and SAP Support
- Need More Help? Contact Support
Your feedback is important to help us improve our knowledge base.
Keywords
KBA , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , Problem
Product
SAP Analytics Cloud 1.0
SAP Knowledge Base Article - Public