As our consolidation report, we need choose the dimension "Scope" and the corresponding dimension "Entity" member. Like below:
Asia Europe Africa Asia Europe Africa
The Scope and Entity have the same strucure, if user want to see "Asia" report, it need choose Scope-Asia and Entity-Asia twice. In order to reduce user manual activity, by using macro, when user choose Scope-Asia, Entity's member automatically be changed to "Asia".
Now, we found the solution make many troubles.
I think our problem is common, so do you have the best practice for it. Thanks.