How to add sibling (new row) to writeback-enabled dimension in Excel 2013 Pivot table?


  • In Visual Studio cube browser we can add new value to dimension, if the dimension is writeback-enabled: right-click a dimension member and click "Writeback", then right-click a dimension member and click "Create Sibling".

    Is there a way to perform similat task in Excel Pivot table? I found a way to edit cell value using What-if Analysis button. But I didn't find a way to add new value to a dimension from Excel.

    Does anyone have any suggestions?

    I use SQL Server 2012 Standart edition, and Excel 2013.



    Friday, July 04, 2014 12:23 PM