Hi Team – I want to understand how we can create a combination of lists and restrict the planning across only those combinations. Please go through below as an example case:
Let’s presume we have two lists: Product and Location.
The product has 4 list items P1 to P4.
The location has 2 list items L1 and L2.
P1 and P2 are associated only with L1.
P3 and P4 are associated only with L2.
I am thinking of creating a compound list as Product_Location which has the values as P1_L1, P2_L1, P3_L2, and P4_L2. This will be a numbered list.
My question is: how do I associate this compound list with the individual list items so the planning is restricted only at the relevant combinations. As an example, how does the value of P1_L1 refer to the value P1 from Product and value L1 from the location? This question also means that the user shouldn’t be able to select L2 as the list item for Location when he chooses either P1 or P2 for the 'Product' list in the page selector.
Hi Prabhu - the compound list can't be identified as a parent-child relationship. That's because the combination might be that the product P3 is not served just at location L2 but also maybe at L1. The example I originally took is, in fact, a simple case but that's not exactly what I meant. The scenario I have is not just the combination of two flat lists Product and Locations. It has in fact 4 different flat lists. But all combinations of list values are not relevant. So, I need to restrict the planning to specific combinations (which I shall get to know). But how do I model that from planning point of view?