select member BPC 10

[michele_medaglia5]

Hi Bpc Friends

I am working on a template in excel using the formula epmsavedata to submit the data in Bpc.

I don't know which EPM function to use to get the below:

In the column reporting unit I would need to give the user the possibility to select row by a row a different member for the dimension Organization selecting from the menu'

Once got that I would like to go a step further ans show to the user only some members of the dimension Organization filtered by a specific node of the hierarchy instead of showing all the dimension members

Thanks

Michele

[former_member186338]

First - requirements are absolutely not clear:

"In the column reporting unit I would need to give the user the possibility to select row by a row a different member for the dimension Organization selecting from the menu

Once got that I would like to go a step further ans show to the user only some members of the dimension Organization filtered by a specific node of the hierarchy instead of showing all the dimension members"

Try to explain once again, step by step with screenshots!

P.S. "epmsavedata" is not a good idea in general...

[michele_medaglia5 · Accepted solution]

ok thanks Vadim for helping with that

[former_member186338 · Accepted solution]

Please accept the correct answer if you want me to help you next time!

[michele_medaglia5]

I was trying to explain to you my scenario.

thanks for suggesting me the function but I have an issue, if I don't specify the member the function give me the below error and I would like the user to be able to select the member

[former_member186338]

Sorry, but you have to specify some member, may be some "dummy" member...

[michele_medaglia5]

Sorry Vadim I will try to explain it better.

we are preparing a template where the user type in the fields and we send the data to bpc using the EPMSAVEDATA. For the column entity we would like that the user doing double-click get a windows with the hierarchy of the dimension and can select the base member that he is looking for

[former_member186338]

Sorry, but what's the issue? I have already answered you: EPMSelectMember

https://help.sap.com/viewer/ec68e48b18a44a49abb12b8ee8ae306f/10.0.36/en-US/f9bced766faf1014878bae8cb...

Last parameter has to be FALSE

[former_member186338]

EPMSelectMember can select individual members in each cell

Still do not understand the process...

[michele_medaglia5]

sorry about that.

I would need to know if there is a function similar to the EPMCONTEXTMEMBER where the user doing double-click can select a member of the dimension organization but the user need to select different IDs, for example in row 1 EntityA, in row 2 EntityC

Thanks for your help

[michele_medaglia5]

thanks for getting back to my message.

I would like that the user double-clicking in the cell can select the member (like epmcontaxtmember) but I need to select a different value for each row

[former_member186338]

Still not clear! Step by step. Each user action!