Writeback to Analysis Services cubes from Excel 2010

Analysis Services have had write back functionality for a long time; however there has been no client support for writeback in the most used BI client on the market (Excel).

One of the new features in Excel 2010 is the ability to perform writeback to Analysis Services cubes. In order to write back to a cube you need to configure a write back partition. This blog post shows how to do this in a step-by-step fashion using the AdventureWorks samples found on http://msftasprodsamples.codeplex.com/