Skip to Content

EPMSelectMultiMemberID - To select multiple members from one hierarchy

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

SCN_1.jpg (18.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Apr 12, 2016 at 07:50 AM

    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

    Add comment
    10|10000 characters needed characters exceeded