Master Detail (Graph to Table) — Oracle Analytics

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

Master Detail (Graph to Table)

Received Response
21
Views
5
Comments
User458365
User458365 Rank 3 - Community Apprentice
edited Aug 13, 2024 7:03PM in Oracle Analytics Cloud and Server

Hi Experts,

I am trying to create a master detail report with bar graph being the master and table being the detail.

Let me know if this is possible.

Thanks

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    Yes it's possible ...

    As you are trying to do it just go till the end and you will see it working

    (If you can't get it working you will need to post details on what you did and how you did it to have a "real" answer)

  • User458365
    User458365 Rank 3 - Community Apprentice

    Gianni,

    Thanks for your reply.

    I did try but could not succeed.

    I had a vertical stacked bar graph as the master and table being the detail. When I change the master view to be table layout then the master-detail works. Not for graph to table.

    When I click on the graph, no changes happen in the detail view.

    Thanks

  • Joel
    Joel Rank 8 - Analytics Strategist

    Hi @User458365

    I don't believe you can use a bar chart as a master view.

    Oracle Documentation states that these are the possible master views:

    • Funnel graph
    • Gauge
    • Graph
    • Map
    • Pivot table
    • Table
    • Trellis (only the outer edges, not the inner visualizations)
  • User458365
    User458365 Rank 3 - Community Apprentice

    Joel,

    Documentation states that graph is supported and I am assuming Bar graph is supported.

    But it also states that Master-detail linking is not supported when you click the plot area of a graph.

    So I see contradictory statements here.

    Thanks

  • Gianni Ceresa
    Gianni Ceresa Mod

    Capture.PNG

    In this example when I click on the bar chart it send the year to the table on the left, so it works from bar chart to table (I just did this sample on 12c right now).

    So it works...

    You don't define a master view, you define the interaction on the column to send a master-detail event, and in the views you just define which view listen to the master-detail event (both can also listen and so you can interact with both in the same time).

    (Just in case I switched to a stacked bar chart like you have and it simply works as expected ... Review your setup, you probably missed something somewhere)