Can i link 2 report in a dashboard that has 2 different subject area?
In an OTBI dashboard containing reports from two different subject areas, can I configure a drill-down functionality where clicking on an element in the first report filters and displays the second report based on a specific related attribute?
For example if i have a an item transaction report contains item number / name / transaction date / quantity / transaction source reference ,
and i have a report contains order (same as transaction source reference ) / sales person / item name.
i want when i run the dashboard for a specific item when i click on one item transaction on the transaction source reference to take me directly to the sale order report where i can see the sales person for this specific item transaction .