SQLBits 2011

Writeback-Here Comes the Sun

With Excel 2010 it is finally possible to modify data in a SSAS cube, without using any macros or third party add-ins. This opens for a lot of common business scenarios like budgeting and planning directly from Excel 2010.
Since the very first versions of SSAS the back end database has supported writeback. With Excel 2010 it is finally possible to modify data in a SSAS cube, without using any macros or third party add-ins. This opens for a lot of common business scenarios like budgeting and planning directly from Excel 2010. Learn how to use Excel 2010 Pivot tables and What-if to publish data back to your cube – including distribution rules, managed sets and slicers. Learn how to write enable a cube and hear about the things you should consider when write enabling your cubes. We go through the limitations and best practice when it comes to building the best and most flexible model for write back.