dbTalk Databases Forums  

Problems with writeback in ADOMD.NET

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Problems with writeback in ADOMD.NET in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Dinnan
 
Posts: n/a

Default Problems with writeback in ADOMD.NET - 06-15-2006 , 09:48 AM






I am developing an ASP.NET application with ADOMD.NET. The application
was originally built using the old COM-based ADOMD and worked fine. I
have now converted the application to ADOMD.NET and now I'm getting
some strange problems when using Writeback.

Some users keep getting errors that say: "Updates cannot be propagated
to cube "XXX" because it is a read-only cube." The strange thing is
that the cube in the errormessage is not the cube I am writing to. I
get this error when I commit the transaction in which I have written
the values to the cube. The correct values are still written to the
writeback table for the cube I'm writing to so I don't think there is
something wrong with the MDX-statement.

If I add the user to the OLAP-administrators group this errormessage
does not show up. The "XXX" cube is not set as write enabled.

I guess this is a security related issue but the same security settings
worked OK when I was using the old version of ADOMD.

I am using Framework 1.1 and the server is Win2003 with SQL2000

What is the problem? Why does ADOMD want to write to a different cube
than the one in the UPDATE CUBE MDX statement?

/Dinnan


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.