Symptom
SAPSetData returns "#VALUE!".
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
Environment
Analysis for Microsoft Office
Reproducing the Issue
- In AO, if use SAPSetData for an existing value as below, it works fine.
- But, if use SAPSetData for non existing value, it does not work.
Cause
SAPSetData only can be used to update the data which the Member Combination exists in Planning Buffer or Cube. If the Member Combination does not exist, it will return "#VALUE!".
Resolution
This is a limitation. Now SAPSetData cannot be used to insert new data in Planning Buffer or Cube.
As a workaround, you can input the data in new lines first in a planning query and click the "Recalculate" button in the ribbon to add the data to Planning Buffer, then SAPSetData works.
- Input data in new lines.
- Click the "Recalculate" button. Query result is as below:
- Now, the new value is in planning buffer, so SAPSetData works.
Keywords
AO, Analysis for Office, Analysis for Excel, formula, , KBA , BI-RA-AO-XLA , Excel Addin , BI-RA-AO-PPA , Please use component BI-RA-AO-XLA , Problem