EPMSelectMultiMemberID function to select multiple member of dimension

[former_member228522]

Hello,

I am using SAP BPC 10.0 SP 4 801.

We want to select multiple member id's of a dimension and then based on these ids we want to override row axis using EPMAxisoverride function.

For this I used EPMSelectMultiMemberID function to select multiple member of dimension but this is not working.

Could anyone please help me how to select multiple member of a dimension or how to use EPMSelectMultiMemberID function.

Best Regards,

Deepak

[former_member186338 · Accepted solution]

Please, show the screenshot of the report...

Provide details of EPMSelectMultiMemberID  usage.

Vadim

[former_member228522 · Accepted solution]

Hello Vadim,

Please find below screenshot for EPMSelectMultiMemberID.

This EPM function is added in EPM10.0 SP 18 add-in version.

I have used VBA code provided by you in post but this is useful to select member for single dimension only. I want to select multiple member ID's of 2 dimension then want to use these members in row axis using EPMDimensionoverride function.

Best Regards,

Deepak

[former_member186338 · Accepted solution]

Hi Deepak,

First I don't see EPMSelectMultiMemberID  usage - empty parameters list etc... have you read help about this function?

And sorry, what do you mean by: "I want to select multiple member ID's of 2 dimension" How????

Vadim

P.S. Please describe the process of user member selection - how you want to arrange it...

[former_member186338 · Accepted solution]

P.S. EPMSelectMultiMemberID  is working absolutely fine:

Vadim

[former_member228522 · Accepted solution]

Hello Vadim,

Thanks a lot..!!

I was using hierarchy name instead of dimension name in second parameter of EPMSelectMultiMemberID.

Best Regards,

Deepak

[former_member186338 · Accepted solution]

Just simple sample with multimember selection and EPMDimensionOverride:

Formula in F7 is the same as in F8:F19 - to generate a list om member ID's without full member specification. The result is used in the EPMDimensionOverride.

Vadim

[former_member186338 · Accepted solution]

Better sample: in the EPMSelectMultiMemberID  it's possible to use property "ID" and have the ID list in the property column:

The concatenation formula will be simple and universal!

Vadim

[vsreeja · Accepted solution]

Hi Vadim,

Need help on this function to select multiple members from one hierarchy.. For example, if in a dimension we are having two hierarchies - PARENTH1 and PARENTH2. Using epm multiselect function I want to get the list of members under PARENTH1 hierarchy alone for selection. Please find the screenshot below:

Kindly help me in this regard. Kindly correct me if my understanding on this function is wrong.

Regards,

Sreeja V

[former_member186338 · Accepted solution]

New discussion please!

And explain the requirements once again - what do you want to achieve and what do you want to avoid...

Vadim

[Former Member]

Hi Deepak,

Go through below link might be useful for you.

Regards,

Sushant.