SetDataCellsUsingMemberScript writes only the last record

giutor73
New Contributor III

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.

1 ACCEPTED SOLUTION

RobbSalzmann
Valued Contributor

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

View solution in original post

2 REPLIES 2

RobbSalzmann
Valued Contributor

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

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!

Please sign in! giutor73