Multiple heirarchy

karank_*4578
karank_*4578
in Modeling

Hi 

We have multiple business units forecasting at product levels. Product heirarchy is pretty standard however forecasting is performed at different level for eg 

 

business unit 1 

product level 1 -> product level 2 -> product level 3 = forecasting is performed here . Actuals will be loaded at  product 3 level 

 

Business unit 2

product level 2 -> product level 3 -> product level 3 -> product level 4 = forecasting is performed here . actuals will be loaded at product level 4 level . 

 

My question is how do manage above scenario without having mutiple duplicate heirarchy 

also how do i manage this on dash boards i.e 

for business unit 1 dashboard drill down goes till level 3 

for business unit 2 dashboard drill down goes till level 4 

 

thanks 

 

Tagged:

Best Answer

  • DavidSmith
    DavidSmith
    Answer ✓

    Hi Karank

    I would set up a composite hierarchy (always better than ragged if possible), Where L4's parent is L3, L3's paretn is L2 etc.

    L1>L2>L3>L4

    The simplest option would be to have a set of modules for the Business Units that need L4, using the L4 hierarchy and a set of modules using the L3 hierarchy

    You can use a subsets of Business Units to ensure you only have relevant BUs for calcs

    The data for the L4 products can then be easily combined with the L3 data from the others

    You would have to have a separate dashboard though, but this could be controlled through roles and contents, or by using the select dashboard based on a list option

    I hope this helps

    David

Categories