I wish to create a cube that can be written to. In MSAS2000 this was a doddle. However, in SSAS2005 all does not go so well.
I have followed the instructions to the letter and also "Googled" how to do writeback in SSAS2005 but whenever I attempt to write to the cube (via ProClarity or XLCubed), I get the following error message "Errors in cell writeback. Cell writeback failed because one of the cells is secured. [Microsoft OLE DB Provider for Analysis Services 2005]".
In order to proceed with my current project, it is important that I get writeback working correctly thus any advice will be appreciated.