Plannable List combinations

GuruAP

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.

 

Thanks for all the support,

 

Regards,

Guru

prabhu

Hi @GuruAP,

 

Step 1:

You can create some List

1. Location List

2. Product List

They are not parent Child

3. # Location_Parent list (Numbered List)

4. Input List (non numbered List, List item - 1,2,3,4.....10) - Purpose is to let business users to enter the inputs.

5. # Product List(Numbered List, with Parent as Location List) - Purpose is Product P1 can be sold in Location L1 and Location L2, so Duplicate list item can't be created in non numbered List.

 

Step 2:

1. Create a module(A), which let the business user to input the data

input List as a dimension

 

 

2. Create a import action: import from Product_Location(above Screen shot) to # Location_Parent list (Numbered List)

 

 

3. Create a new Module(B), which we will be performing actual calculation.

(# Location and Product List as Dimension)

 

Here i created a unique Product code for all Products, which the business users had given as input. you can get Product code from business team.

The purpose of creating unique code is to populate this data into # Product List(Numbered List, with Parent as Location List)

 

4. Importing the unique code into # Product List(Numbered List, with Parent as Location List)

 

 

5. Create a blank module (input List as Dimension) and Blank as Line item(no Data Format) - Purpose of this Line item is to make blank values, which the business user has entered in Module (A)

 

Create a import action from Blank module to Module (A)

 

 

You can put all 3 actions into 1 process

and you can use dependent drop down as explained in previous post- to make it easier for business user.

 

 

Hope i made sense.

 

 

Thanks,

SORNA RAJA PRABHU