i´ve got an hierarchy and a fact table. There are only facts for the lowest hierarchy level. And now, i want to show the hierarchy paths just for those who have facts.
It´s not a problem creating the hierarchy, but when i use join or exists for reducing, the hierarchy is destroyed and as a result, i just see the lowest level of it.
I´ve attached an example. Only John and Mary have sales. And because of that, the hierarchy should be reduced to themselves and their parentnodes, like this:
