Filter Member by properties via Member Selector in EPM 10
I need a help about filter member by properties in member selector window. I want to restrict members automatically. For reducing incorrect inputs, when users choose A dimension's member, system have to restrict B dimension's member with A property automatically. Is there anyway to solve this issue?
If you look at the context function, there is a parameter for filter. That filter should be maintained as the context of the business area dimension.
Lets say the property in the cost center dimension is BA, then in one of the cells, write the below formula:
=EPMContextMember(,"Cost Center", "BA=EPMContextMember(,"Business Area"))
Now, if you double click on this cell, the member selector will open and the associated filter will be applied automatically.
Hope this helps.