Forum Discussion

giutor73's avatar
giutor73
New Contributor III
5 months ago

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.

  • 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!