SAC Excel Addin - SAP.SETDATA only retrieves the current value and not writing anything

[mfrieser]

Hello,

I am trying to use the SAP.SETDATA formula.

When defining my table, value and dimensions I want to write, I only get back the value currently saved on my defined dimensions. The value I set in the SETDATA parameters is ignored.

Am I missing something important here?

Thanks and best regards

Michael

[mfrieser]

Thanks Jeanne, I processed the data and now it is working!

[bigonnet · Accepted solution]

Hi ,

The "set data" returns initially the amount stored in SAC back end .

So before "processing" you can only see what is stored before your data entry in C38.

So please "Process" the data contained in cellC38 and then "Publish" it. Then the cell will show the new entry .

Thanks

Jeanne

[JefB]

Hi Michael,

I thought that you cannot save data on a parent node?
The year 2023 (Cell G12) seems like a hierarchy node in your table... but you have to use a leaf member of Date dimension.

[mfrieser]

Yes thats true.

But as I did not process the SETDATA formula, I did not write on the node (I did not write anything, in fact).

When I process the SETDATA formula on node like in the screenshot, I get a message that I can only write on leaf-level.

BR

Michael