Master Detail (Graph to Table)

User458365

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

Gianni Ceresa

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

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

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

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

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)