Selecting a value in a chart filters other charts in the report

Question

Hi,

I am working on an Analysis in OBIEE.

I have 1 table with Countries list and their sales information.

I have another Bar chart with Products and their Sales information.

So, whenever I click on a Country in the Table, the bar chart should be filtered with the products that are sold in that selected country and the sales happened for that product in that country.

Below is a sample data and charts for your reference. Please suggest.

CountryName           SalesAmount

UnitedStates               $60,000

Japan                          $20,000

Sweden                       $40,000

Sales Amount by Product name

Thank you!

Gianni Ceresa · Answer

The feature getting closer to what you describe is called "master-detail" : you have a master view which allows to set selections on details view.

In your case you will need to add the country as a chart prompt field for your products chart. Setting the country in the table view to be the master and the products bar chart to be the slave, clicking a country in the table will change the value selected in the dropdown of the product view.

What you are going to lose is a view of product across all countries as the dropdown will always have a value (but you could add a calculated value named "all" to fake it?).