Building a Write-Enabled Cube

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 application in my next post, but for now I’ll focus on the cube. The…


A Technical Review of the Simple Demonstration

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, the analyst connected to a write-enabled cube, assembled a PivotTable, write-enabled the PivotTable, entered data…


Sidebar: The Other What-If Analysis Options in Excel

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-based models and are exposed on the Data tab.  More information on these alternatives is found here….


A Simple Demonstration of What-If Analysis

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 takes place within a fictional company. Through this process, projects are submitted from across the organization by…


Understanding What-If Analysis

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 materials inventory?  How might that impact costs?  How might that impact the reliability of product delivery?…


Building a Writeback Application with Analysis Services

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…

3