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

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

Received Response
1
Views
1
Comments
Pradeep_Kumar
Pradeep_Kumar Rank 1 - Community Starter
edited Aug 13, 2024 5:20PM in Oracle Analytics Cloud and Server

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

pastedImage_2.png

Thank you!

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    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?).