Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Hierachie through multiple dimensions

Received Response
1
Views
3
Comments
Benjamin Frankly Maybe
Benjamin Frankly Maybe Rank 1 - Community Starter
edited August 2024 in Oracle Analytics Cloud and Server

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.

pastedImage_0.png

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

Answers

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    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.

  • Benjamin Frankly Maybe
    Benjamin Frankly Maybe Rank 1 - Community Starter

    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
    Thomas Dodds Rank 8 - Analytics Strategist

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