SSAS 2008 MOLAP Writeback (2)
In a recent post, I started investigating around a new Analysis Services 2008 feature: writeback partition with MOLAP storage.
Unfortunately, I got stopped by a bug in SQL Server 2008 CTP 5 which disallowed me from committing my updates.
SQL Server 2008 CTP 6 is now available. I can now continue from where I stopped last time.
Committing updates
After our UPDATE CUBE MDX command from SSMS, let's run a COMMIT TRAN statement to validate our transaction.
This step works perfectly with CTP 6. We can see records inserted by SSAS into the writeback table.