You need to ensure that the Organization and PercentageOfOwnership hierarchies are not visible to users
You need to write-enable one of the linked measure group partitions to support Microsoft Excel 2010 PivotTable What-If Analysis