List Duplicate Value Issues Hub Model

Jojo88
Jojo88
in Modeling

Hello, 

 

In our hub model, we have a sales planning list (L1 Plants) with top level item All Plants. We have other sales planning list (L3 Profit Center) with top level item All Profit Centers

 

We have mapping list L3 Profit Center- L1 Plant with parent hierarchy as L1 Plants. 

 

We have a new use-case where profit center rolls up to multiple plants. Mapping list will not accept duplicate (Profit center) under different plants. 

 

Ex:

Profit Center- Plant 

100505 - Plant A 

100506 - Plant B 

 

New Adj 

Profit Center- Plant 

100505 - Plant A 

100505 - Plant B 

100506 - Plant B 

This use case did not exist when our model was originally built. 

 

Looking for advice/information on how to adjust for this. 

 

Tagged:

Best Answer

  • Jitendra.Vishnolia
    Jitendra.Vishnolia
    Answer ✓

    Hi @Jojo88 ,

     

    Mark mapping list L3 Profit Center- L1 Plant  as a numbered list and concatenate codes of Plant (L1 Plants)  and Profit center(L3 Profit Center), then you will have unique codes for mapping list L3 Profit Center- L1 Plant with parent hierarchy as L1 Plants.

    In this way your issue of duplicate (Profit center) under different plants will be resolved.

     

    ~ Jitendra

Categories