Skip to Content
Former Member
May 25, 2016 at 02:14 AM

Only need choose dimension "Scope"



As our consolidation report, we need choose the dimension "Scope" and the corresponding dimension "Entity" member. Like below:

Scope: ENTITY:

World World

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.