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.
ALM_SupportAsked:
Who is Participating?
 
ALM_SupportConnect With a Mentor Author Commented:
I have finally found the answer.  On the cell data tab, simply putting a tick in the checkbox for "Enable read/write" is not enough.  One must also add an MDX statement.  In my case I uses 1=1, ie allow all cells.

As with SQL2000 AS you still cannot write to calculated measures.
0
 
Auric1983Commented:
What version of SQL are you running on?? I believe that SQL 2005 Enterprise is required for writeback functionality
0
All Courses

From novice to tech pro — start learning today.