Skip to Content
0
Nov 28, 2016 at 11:21 AM

Multiple List Box in Input Template

89 Views Last edit Apr 27, 2017 at 09:53 AM 4 rev

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 ?

Attachments

bpc-sc-1jpeg.png (24.6 kB)
bpc-sc-2.jpg (57.5 kB)
bpc-sc-3.jpg (50.7 kB)