Query on Master Detail Model

Question

I have a master table with 5 column, of which first column is having list of all attributes (say age,salary,years in job), rest 4 is having values like standard deviation, mean, mode and deviation. So master table is having 3 rows only. Now the detail table is having 3 column (age, salary, years in job) having records of say 50 people.

I want to create a dashboard with master table as master view and when user click on any of the  specific row (representing one attribute one row) the detail should show the bar chart with slabs on x axis and y axis as percentage.

I am new to OBIEE, so not able to decide on how to design it and how to map so that click on one row of master show me bar chart of that attributes distribution (based on data in the detail table)

Problem is I can not change the structure of these two tables as they are existing tables and are used in other reports.

Please help me in understanding the model if it is possible.

Felipe_Idalgo · Answer

+1 @cesar.advincula.o

note that detailed analysis must have a a filter used in navigation this type of filter will depend if the data of the analysis are correlated or not

Post a picture of your model (physical, logical...)

Felipe Idalgo

cesar.advincula.o · Answer

It's.possible

1. Create two analysis objects, one with your master view the second with your.detail.view.  In the master detail detail you could.create.your.views and the second create your bar chart percentage.

2. Create your presentation variable in.your.dashboard.prompt to pass the parameters,.for your master view.

3. Create the.action links in your master master view in the column that you want. And.search your.detail.view to.pass.the parameters.

Kind regards,