Skip to main content
Newcomer
Jul 5, 2024 9:19 AM UTC
Solved

SetDataCellsUsingMemberScript writes only the last record

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.

RobbSalzmann
Employee - Advisor
Jul 6, 2024 1:44 PM UTC

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

2 replies

RobbSalzmann
Employee - Advisor
Employee - Advisor
Jul 6, 2024 1:44 PM UTC

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
Newcomer
Jul 8, 2024 7:45 AM UTC

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!