Forum Discussion

giutor73's avatar
giutor73
New Contributor III
10 months ago
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.

  • 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's avatar
    RobbSalzmann
    Valued Contributor II

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

    • giutor73's avatar
      giutor73
      New Contributor III

      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!