NOTE This is part of a series of entries on the topic of Building Writeback Applications with Analysis Services . Up to this point, we’ve focused exclusively on the update of measures using cell writeback. When we need to insert, update or delete...

NOTE This is part of a series of entries onthe topic of Building Writeback Applications with Analysis Services . A parent-child hierarchy consists of members with which values are associated at various levels. A frequently cited example of such a hierarchy...

NOTE This is part of a series of entries on the topic of Building Writeback Applications with Analysis Services . In my previous entries on this topic, I’ve been writing data to the Score measure at the intersection of an individual project and...

NOTE This is part of a series of entries on the topic of Building a Writeback Application with Analysis Services . Writeback to cubes through Excel applications is used extensively within Microsoft to support a number of our internal processes, including...

NOTE This is part of a series of entries on the topic of Building Writeback Applications with Analysis Services . If you have not read the other posts in this series, you will want to read A Technical Review of the Simple Demonstration before proceeding...

NOTE This is part of a series of entries on the topic of Building Writeback Applications with Analysis Services . To build a writeback application, you need a write-enabled cube and an application with which to interact with it. I’ll cover the...

NOTE This is part of a series of entries on the topic of Building a Writeback Application with Analysis Services and makes direct reference to a previous post containing a simple demostration of what-if analysis . In the simple demonstration of writeback...

NOTE This is part of a series of entries on the topic of Building a Writeback Application with Analysis Services . What-if analysis against Analysis Services is just one form of what-if analysis supported by Excel. Other forms focus on spreadsheet...

NOTE This is the second of a series of entries on the topic of Building a Writeback Application with Analysis Services . To demonstrate writeback with Analysis Services, I’ll leverage a simple model built around a project selection process that...

NOTE This is the first of a series of entries on the topic of Building Writeback Applications with Analysis Services . Business analysts frequently encounter questions focused on the impact of potential change: What if we raised our parts and...

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...