3763022 - SAC Add-in : Issue with SAP.SETDATA formulas when Process Data

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.

SAP Analytics Cloud SAC Excel Add-in - Add-in Version 1.23.0.2 - Application Version 2026.9.188

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.

KBA , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , Problem

SAP Analytics Cloud 1.0