About Aaron82

This would be a great feature. ... View more

Hi Joh04924 and others pursuing the L2 course,   I would recommend looking at the system modules already available to you that align the parents for each hierarchy level.  Readily available are the Product Details and SKU Details modules which list the parents in their modules.     Create a new (intermediary - they make it sound more scary than it is) module that takes the growth rate line item by Product Family and write the lookup for SYS04 Product Details.Product Family.    Then in the Demand Forecast module, do the same but for SYS08 SKU Details.Product  The second one would look like so: 'DEM02 Volume Growth Rates by Product'.Growth %[LOOKUP: 'SYS08 SKU Details'.Product]   Cheers, Aaron   ... View more

I'm experiencing the same obstacle with a new model we are developing for Operating Expense forecasting and planning. Our corporate functions plan at the Cost Center level (not always) and if we go the balanced route our hierarchy will go down 9 levels. It creates a lot of dummy clicks for our users and something we really don't want to do.  ... View more

This would be an awesome feature for model development.  ... View more

This would save a good amount of time building out dashboards that are long. ... View more

Very helpful for learning how to build out using existing views and developing best practices for the new UX.  ... View more

Hi Davrae, It looks like the logic may need adjustment. Try this. IF Dept Code >= 0000 AND Dept Code <= 5999 OR Dept Code = 6500 OR >= 7000 AND Dept Code <=7199 THEN UPG Admin FB Rates.Fringe Rate[LOOKUP: Staff Types (UPG)] ELSE IF Dept Code >= 6000 AND Dept Code <= 6999 THEN UPG CPG Fringe Rates.Fringe Rates[LOOKUP: Staff Types (UPG)] ELSE IF Dept Code >= 8700 AND Dept Code <= 8799 THEN UPG RPCN Fringe Rates.Fringe Rate[LOOKUP: Staff Types (UPG)] ELSE IF Dept Code >= 8000 AND Dept Code <= 8600 THEN UPG RPCS Fringe Rates.Fringe Rate[LOOKUP: Staff Types(UPG)] ELSE 0 ... View more