Hierarchy view mode disabled after filtering EPMContextMember

[former_member185511]

Hi,

I have a scenario that users should choose dimension members from hierarchy but based on level that i filter before the selection. Lets assume i have 5 level under PARENTH1 but i want user to see members till level 3 and choose from there (and other input form will have different level). I can control level with an attribute but after giving the filter, hierarchy mode is disabled and all the members appear on LIST mode.

Screenshot is attached.

Hierarchy is working on this formula (no filter) =EPMContextMember(,"PROJECT","",1)

Hierarchy is NOT working on this formula (no filter) =EPMContextMember(,"PROJECT","<filter values>",1)

I don't want to develop my own treeview control just for this purpose.

Thank you!

[Former Member · Accepted solution]

Hi Bilen,

This is the standard behavior of filter on context member formula.

You can't display a sub tree.

Andy