Hi - I have five levels of hierarchy for one dimension and four levels for another dimension. The forecast is generated at these two dimensions at the lower levels of the hierarchy and the ask from the business is that they can input any level in the hierarchy - there are different types of inputs from different stakeholders, at region level or DC level. If the logic for disaggregation is based on the baseline forecast, what is the smart way of building it? I am thinking of break-back functionality but with different levels and to ensure the disaggregation happens based on the generated baseline forecast at the lower level, I should first need some data in the break-back line item in that proportions. Also considering inputs coming from different people and to record these inputs, I am not sure if the break-back functionality is something that becomes useful for me in this context. Is there no other way other than creating those number of modules at different possible levels and then write the disaggregation logics all by myself?
I want to understand from the community for any smart way of achieving the same. Also, I would like to know how complicated the disaggregation logic based on last three months average will become in relation to the disaggregation based on the generated baseline forecast.
Thanks for all the inputs,
Regards - Guru