Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Filter Member by properties via Member Selector in EPM 10

Hi Gurus,

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?

Best regards

Ha┼čim

Former Member
Former Member replied

Hi,

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.

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question