cancel
Showing results for 
Search instead for 
Did you mean: 

Filter for Particular Hierarchy

Former Member
0 Kudos

Dear experts,

We have 4 different hierarchy in entity dimensions. We want to filter based on hierarchy for different report.

EPMContextmember doesnt allow this feature . We tried to pass PARENTH4=X, but no success. We want to just enable a particular hierarchy for particular report.

Is there any EPM function for this??

regards,

Accepted Solutions (0)

Answers (2)

Answers (2)

anil_agrawal
Active Participant
0 Kudos

Hi ,

Please go to Report Editor  and select entity dimension , In EPM Member Selector you will find filter option . In “ property “ select your Hierarchy i.e. PARENTH1,PARENTH2 and so on , give the “operators” and “value” options  selection as per your requirement and finally click on “Add Dynamic Filter”.


For Reference please have a look to the below image :-


Thanks

Anil

former_member186338
Active Contributor
0 Kudos

Unrelated to the question asked!

former_member186338
Active Contributor
0 Kudos

Sorry, but what do you mean by: "just enable a particular hierarchy for particular report"

If you add any filter to EPMContextmember then you will not see hierarchy - only flat list!

Vadim

Former Member
0 Kudos

ok . our requirement is to get a selection of a particular hierarchy in  a dimension selection in a report. We need to have a view of single hierarchy in a report where user can select amember of node under that particular hierarchy.

former_member186338
Active Contributor
0 Kudos

1. You can try to achieve your goal using security (allow access to the nodes of one hierarchy). This approach will restrict access for all reports etc...

2. You can create your own VBA form for member selection (complex job). VBA expert required.

No other solutions.

Vadim