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 |