Best Solution is to Keep PLANS in mind. Whenever we design a model we make sure that it follows all the best practices and is quite aligned with PLANS. As you can see your company starts to ship to France from America - your model should be capable enough to scale up and sustain itself as soon as there is any such requirement
Must Read article
https://community.anaplan.com/t5/Best-Practices/PLANS-This-Is-How-We-Model/ta-p/33530
Models should be designed and built keeping future in mind and Scalibility & Sustainability are one of the top metrics in this.I know that is not what you were looking for. But thought of sharing this in case if you haven't gone thru this already.
On your solution the quickest way to do is to create a hierarchy the way you have done it
Hope this helps
Misbah
Best Solution is to Keep PLANS in mind. Whenever we design a model we make sure that it follows all the best practices and is quite aligned with PLANS. As you can see your company starts to ship to France from America - your model should be capable enough to scale up and sustain itself as soon as there is any such requirement
Must Read article
https://community.anaplan.com/t5/Best-Practices/PLANS-This-Is-How-We-Model/ta-p/33530
Models should be designed and built keeping future in mind and Scalibility & Sustainability are one of the top metrics in this.I know that is not what you were looking for. But thought of sharing this in case if you haven't gone thru this already.
On your solution the quickest way to do is to create a hierarchy the way you have done it
Hope this helps
Misbah