ALM_Support
asked on
SSAS2005 Writeback Woes
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.
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.
Auric1983
What version of SQL are you running on?? I believe that SQL 2005 Enterprise is required for writeback functionality
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.