Getting fact table data based on traversing a Flat hierarcy table

HI all,   I have put a lot of work in building a Flattend hierarchy table in my data model but now I want to use it in certain ways but I cannot figure out how to make it work.    My data looks a...