Unable to write back to leaf cell using AS2005 -
02-15-2006
, 04:10 PM
Hi -
Has anyone gotten writeback to a leaf cell to work in SSAS 2005.
I have a test program that I have written in C++ using ADO MD that
allows me to writeback to leaf cells by updating the cell's value
property in a matching set of connection transaction methods against a
test database that I am running on MSAS 2000.
Everything works fine until I migrated the database to SSAS 2005.
I can no longer writeback to leaf cells using my test program. I am
able to begin a transaction, set the new value, and then commit the
transaction.
But when I rerun the query, the data doesn't change and when I look in
the writeback table in the underlying database, there isn't a new row
with the writeback data.
In both MSAS 2000 and SSAS 2005, the underlying database is on
Microsoft Access and I am using the Microsoft Jet 4.0 OLE DB Provider.
I made sure that I enabled a writeback partition in my database, that
all users have Read/Write Access writes to the cube and there are no
Cell Data restrictions.
Anyone have suggestions on what I should try next?
Thanks in advance |