| SSAS 2008 MOLAP Writeback (2) |
| 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 updatesAfter 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. |
Top Rated
- SSAS Implementation Best Practices slides in PDF format
- SSRS Report Against a SSAS Parent Hierarchy
- Handling inter-dimensional members dependency and reducing cube sparsity using reference dimensions in Analysis Services 2005
- Cube structure optimization for MDX query performance in Analysis Services 2005 SP2: Tips for Parent Child Hierarchies usage
- Handling Multiple Calendars with a M2M Scenario
- Passing MDX parameters in Reporting Services reports
- Using UserName to Control Data Access and Default Member in SSAS 2K5 (Carrie Williams)
- SSAS Tutorial: SQL Server 2005 Analysis Services Tutorial by Accelebrate

