Skip to Content
0

Multiple List Box in Input Template

Nov 28, 2016 at 11:21 AM

63

avatar image

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)
10 |10000 characters needed characters left characters exceeded

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

0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Vadim Kalinin Nov 28, 2016 at 12:17 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Nov 28, 2016 at 12:42 PM
0

Something like here:


list.png (53.2 kB)
Share
10 |10000 characters needed characters left characters exceeded