Skip to Content

Multiple List Box in Input Template

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 ?

bpc-sc-1jpeg.png (24.6 kB)
bpc-sc-2.jpg (57.5 kB)
bpc-sc-3.jpg (50.7 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 28, 2016 at 12:17 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 28, 2016 at 12:42 PM

    Something like here:

    Add comment
    10|10000 characters needed characters exceeded