Is there a option for user to select from dropdown to allow "ALL",single selection&multi selections.

[former_member566000]

Hi,

I am currently working on BPC 11 standard and was looking for how to give option for user to select from drop down to allow "ALL" ,single selection, and multi selections.

Thanks!

[former_member186338]

Drop down where? Report, input form, DM package? Some sample, please!

[former_member566000]

User selection in input form.

Thanks!

[former_member186338]

Again, sample please! Provide some screenshot!

How do you want to use user selection?

Step by step...

[former_member566000]

Hi,

We want to give selections in page axis, which looks something like below

Thanks!

[former_member186338]

Sorry, but I don't understand how do you want to select multiple members in drop down???

Without any relation to BPC, drop down style control is not used for multiple selection - single item is shown after selection. Theoretically it's possible to write in VBA some custom combobox with multiselect, but it's not a trivial task.

Instead of combobox you can use listbox, that allows multiple selection. Then, using VBA you can get selection result and pass it to EPMDimensionOverride for dimension in page axis (supported from some EPM SP).

P.S. "ALL" can also be an issue - multimember for page axis is limited to 30 members only. Some root parent member has to be used instead of the list of all members.

[former_member186338]

P.S. You can look on the sample of multiselect list box at the end of my blog:

https://blogs.sap.com/2017/09/21/bpc-nw-10-vba-function-to-get-dimension-members-list-by-property-va...