cancel
Showing results for 
Search instead for 
Did you mean: 

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

mfrieser
Participant
0 Kudos
494

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

Accepted Solutions (1)

Accepted Solutions (1)

bigonnet
Product and Topic Expert
Product and Topic Expert
0 Kudos

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

Answers (1)

Answers (1)

JefB
Active Contributor

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
Participant

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