aW4P

a Writeback for PowerPivot - Overview

aW4P is a VSTO add-in for Microsoft Excel 2013 and Excel 2016 that enables you to writeback Power Pivot model.
The main idea is to extend a generic tabular model by a collection of writeback partitions in which to save the delta values generated by spreading algorithm.
Every writeback table belongs to a listobject that play the role of storage by the linked-back source mode of PowerPivot
The extension is driven by a writeback settings defined by an ad hoc UI ( see User Guide for more details ) and results in a new cloned workbook.
In these prepared and recognized workbook it is possible to writeback data in place of any hosted pivots.

Let's illustrate by an example these concepts.
In the workbook provided in Samples section we have the following model

There is a fact table 'V Qty'. The columns Qty, Qty2, etc contain values. Others, like Option, Store, Week, are the granularities columns. They have links with other tables that we can imagine to be the dimension tables in Multidimensional modeling. Of course i have in mind a classical star schema. In order to view the values in a pivot it needs to create the corresponding measures. In the example i created the measure [Qty M] linked to 'V Qty'[Qty] column, etc...

The deploy phase extends the model adding for each table declared editable a new mirror table that have the same links of parent.

Every writeback table belongs to an Excel linked-back table

And every involved measure is modified in order to reference the writeback contribution.