Don't have Telegram yet? Try it now!
https://www.rossgoodman.com/2007/10/12/dimensionally-modelling-a-recursive-hierarchy/
Dimensionally Modelling A Recursive Hierarchy