1

I am using Oracle Business Intellgience (12c) and let's say I have a report resulted from an execution of the following query

select code_filial, max(paid) as maximum_pay
from leads_history
group by code_filial

It will return a table with highest budget value related to the each filial. Now what i want is the following: when i click to max(paid) result in a table, another table should appear with the information about max(paid) account. I tried master-detail relationship, but couldn't succeed. Can anyoune help with that?

Sherzodbek
  • 170
  • 1
  • 20

1 Answers1

1

That's out-of-the-box functionality. As soon as you make a navigation action link to another analysis where your code_filial is set to "is prompted" the context will be passed and the analysis filtered.

Chris
  • 2,706
  • 2
  • 13
  • 15