cancel
Showing results for 
Search instead for 
Did you mean: 

EPMSelectMultiMemberID - To select multiple members from one hierarchy

vsreeja
Explorer
0 Kudos

Hi All,

Need help on this function - "EPMSelectMultimemberID"

In my scenario, I have two hierarchies PARENTH1 and PARENTH2 in my dimension, from which I want to do a multiselect for the members. Based on our business requirement, we have grouped dimension members to two hierarchies. So in one sheet, we need to select multiple members from PARENTH1 and in other sheet we need to select multiple members from PARENTH2. But using this function, if I am specifying the hierarchy name, I am not able to do the selection. Please find the structure of our dimension in the screenshot below.

So, we will be selecting members under the node - 'ASSG' of PARENTH1 hierarchy such that we will be able to select the members from PROJ_1, PROJ_2,PROJ_3,PROJ_4. Similarly for others as well.

Please guide me in this regard.

Regards,

Sreeja Viswanathan

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member186338
Active Contributor
0 Kudos

Hi Sreeja,

To my mind the syntax dimension:hierarchy is not applicable to bpc connections. Only dimension can be used - not possible to select hierarchy.

Vadim

vsreeja
Explorer
0 Kudos

Hi Vadim,

Thanks for your quick reply..

Is there any other way of addressing this requirement.

Regards,

Sreeja V

former_member186338
Active Contributor
0 Kudos

May be there is a solution, but using VBA API...OpenFilteredMemberSelector