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 ?