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 |