Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Help: Analysis Services write back problem.

Author  Topic 

silvaxia
Starting Member

1 Post

Posted - 2008-10-10 : 05:07:11
i have set the partition and enable write back,and process. In relational database, i see the writeback table has also been generated.


Now my problem is:

I have execute the statement: update cube ... set .... where .... in MS Sql Server Management Studio New Query, but as result, only the data in olap has been updated successfully, No any records were inserted into the writeback table in relational database.


Why? Did i miss something?


Thanks for any comments.

Newbe
Starting Member

1 Post

Posted - 2009-11-09 : 06:51:17
silvaxia

Did you execute the:
commit transaction; command?
Go to Top of Page
   

- Advertisement -