Dimension writeback: does it update the datasource as well or only the cube?

Dimension writeback: does it update the datasource as well or only the cube?

I cannot change the underlying data but want to fix the data in a dimension, so I enabled writeback.. only I get errors as the writeback tries to update the underlying data source. (the user has readonly writes by design).

Hello. I am not sure about what version of Analysis Services you are talking about, but the answere is yes. The members you create with dimension writeback are written in your source dimension table.

HTH

Thomas Ivarsson