Solved

SSAS2005 Writeback Woes

Posted on 2010-09-02
2
423 Views
Last Modified: 2012-05-10
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
Comment
Question by:ALM_Support
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 16

Expert Comment

by:Auric1983
ID: 33616973
What version of SQL are you running on?? I believe that SQL 2005 Enterprise is required for writeback functionality
0
 

Accepted Solution

by:
ALM_Support earned 0 total points
ID: 33617280
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

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question