Answered by:

Question

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.

If you have any concern about this behavior, you can submit a feedback at
http://connect.microsoft.com/SQLServer/Feedback and hope it is resolved in the next release of service pack or product. Your feedback enables Microsoft to make software and services the best that they can be, Microsoft might consider to add this feature
in the following release after official confirmation.

Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.