Multiple List Box in Input Template

[former_member419358]

Hello Everyone,

I am working on BPC 10.1 system. I have a requirement to build an input template with having 3 dimensions in row out of which 2 dimensions will show list box option so that all 3 dimensions together won't show N*N relationship with combination of all of their members.

Please find below screenshots of my requirement. I would like to have Channel and UOM as list down box. I tried to use Data Validation option from excel but I could use only one list down box when I am logged in BPC. When I try to use UOM as list down box then system give me error.

1. Channel List Down Box

2. UOM List Down Box

3. Error when I put UOM as list down box

Please let me know if there is a possibility to put multiple list down box in one input template or not ?

[former_member186338]

Secondary tag is not relevant for this question - remove it!

[former_member186338]

Something like here:

[former_member186338]

You can do it if you have fixed number of rows...

Use separate cell for data validation list and reference this cell in epmolapmember formula.