cancel
Showing results for 
Search instead for 
Did you mean: 

Limit the members selection in EPMContextMember

Former Member
0 Kudos

Hi

I've used a formula =EPMContextMember so that user can choose the member in dimensions "B_TIME". It displays all members along with the hierarchy.

Should I want the selection for 2015.TOTAL and it's descendants, hiding all other years, how do I do that?

If I put the filter "PARENTH1=2015.TOTAL", it shows the Quarters but not the Periods / Months. I would need it to show the hierarchies and all descendants under it... in Hierarchy format / view, not just a list of members.

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member186338
Active Contributor
0 Kudos

Simply not possible in the current EPM version. You may write an idea in the ideaplace...

Vadim

former_member225135
Active Contributor
0 Kudos

Hi Edmund,

You can try something like this:

=EPMContextMember(,"TIME","YEAR=2015")

But again, it will show the selection as list not as hierarchy. This is the standard behavior of filter on context member formula.

You can't display a sub tree.

Regards,

Rahul