dbTalk Databases Forums  

Unable to write back to leaf cell using AS2005

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


Discuss Unable to write back to leaf cell using AS2005 in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
joshkpeng@hotmail.com
 
Posts: n/a

Default 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


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.