SSAS Articles SSAS 2008 SSAS 2008 MOLAP Writeback (2)
SSAS 2008 MOLAP Writeback (2)
User Rating: / 0
PoorBest 
Written by Michel Caradec   
Sunday, 24 February 2008 16:11

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.

Read more...