Hierachie through multiple dimensions

Question

Hello Community,

A customer wants a hierachie (not a drill path) that will go over multiple dimensions. He wants the hierachie over a drill path because he wants to see all other customers while looking in Detail at a certain customer.

Below an Image of the Report with 3 hierachie columns. The Goal would be to get all those 3 in one column.

Has someone had a similar request and could solve it? I would be tahnkful for any hints or links to a possible solution.

Thomas Dodds · Answer

Perhaps something in here might help you...  Expanded view of hierarchy

Benjamin Frankly Maybe · Answer

Thank you Thomas I did it your way. Is there a way to make the hierachie tree open all Sub Branches of a leafe at once? When a customer Name is choosen in the hierachie tree, the site and item Level beneath that customer shell open not only the site Level. I don't want to drill because all other customers must stay visible all the time.

Thomas Dodds · Answer

If you truly want a hierarchy of those three then based on the transactional relationships it's pretty straight forward to build a flattened hierarchy table then import into OBIEE and model.