How to control allocations when using write-back in Excel 2010
One of the first questions that I usually gets when showing write-back in Excel 2010 to Analysis Services cubes is how you can control the allocation of values between dimension members. By default you will get an equal allocation based on the number of dimension members.
Tags: excel, management, writeback