Recently, I delivered a presentation at the 2012 PASS SQL Rally titled Building a Writeback Application with Analysis Services. Based on feedback from that session, I’ve decided to address this topic in my blog, making this information accessible to a wider audience and allowing me to address various points in a bit more depth than the 1-hour presentation format allows.
There’s quite a bit of ground to cover here, so I won’t attempt to do this as a single blog post. Instead, I’ll spread this over a series of entries, each covering a bite-sized chunk of the material. I will address both cell writeback and dimension writeback, explain and demonstrate the interaction with Analysis Services, and provide code and database samples so you can try this at home. As new entries to this series are added, I will update this page which will serve as a kind of table of contents to the series. I hope this information is helpful and I look forward to your feedback.