Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 433
  • Last Modified:

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.
0
ALM_Support
Asked:
ALM_Support
1 Solution
 
Auric1983Commented:
What version of SQL are you running on?? I believe that SQL 2005 Enterprise is required for writeback functionality
0
 
ALM_SupportAuthor 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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now