Skip to main content
July 5, 2024
Solved

SetDataCellsUsingMemberScript writes only the last record

  • July 5, 2024
  • 1 reply
  • 0 views

Hello folks,

Is there an explanation why SetDataCellsUsingMemberScript() writes to the cube only the last value from a list? If the list is formed by 10 records only the last one is written. It seems it keeps writing to the same intersection by continuously overwriting instead of adding.

Best answer by RobbSalzmann

I suspect this has to do with the way you're looping through the cells.  Post your code and we can take a look.

1 reply

July 6, 2024

I suspect this has to do with the way you're looping through the cells.  Post your code and we can take a look.

giutor73Author
July 8, 2024

Thanks for the reply. It was indeed. I moved the call to setdatacell inside the for loop clearing the list just immediately after before the next iteration and it worked!