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.
- Understanding What-If Analysis
- A Simple Demonstration of What-If Analysis
- Sidebar: The Other What-If Analyses
- A Technical Review of the Simple Demonstration
- Building a Write-Enabled Cube
- Building a Custom Writeback Application
- Sidebar: The MS IT Pattern for Custom Writeback Applications
- Understanding Allocations
- Sidebar: Allocation across a Parent-Child Hierachy
- Introducing Dimension Writeback
- Writeback to a Parent-Child Dimension
- Writeback to a Regular Dimension
- Managing Writeback Cubes
- Writeback Sample Downloads