dbTalk Databases Forums  

Writeback does not work on SQL, works on Access

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


Discuss Writeback does not work on SQL, works on Access in the microsoft.public.sqlserver.olap forum.



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

Default Writeback does not work on SQL, works on Access - 09-11-2003 , 02:27 PM






I've been struggling with a writeback problem on AS for the last few
days. Everytime I use the 'update cube command' to write data to the
cube (writeback is enabled, of course), the numbers get multiplied by
1 billion(10^9) on the cube, not on the writeback table. If I keep
modifying this number, eventually AS will return and OLE DB error (I'm
using the MDX Sample Application) which seems be related to an
overflow, as the numbers keep getting larger and larger. The error is
'Multiple Step OLE DB...No work was done'. Today I tested the
writeback on Foodmart2000, and it worked. Access uses a different type
of OLE DB Provider (Jet). Would anyone have any thoughts on the
reasons this might be happening? Our budgeting system is down because
of this problems.

Thanks in advance
Alex Almeida

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.