Oracle Analytics and AI

Christian Flegler

Hi everyone,

I’m working with two custom Data Model Reports in Oracle BI Publisher, and I’d like to know if there’s a way to drill down from one report (Project) to another (Cost in each Project). These reports are related via a foreign key (Project ID).

Is there a recommended approach or best practice for implementing this kind of drill-down functionality between custom reports? We don't want to use Analytics-Reports.

Thanks in advance for your help!

Regards,

Christian

Hassan El Bouihi-Oracle

Hello Christian,
You need to explore the usage of Dashboards and build prompts that are dependent on other prompts.
For example, you can have a header report with its own prompts.
In a different section of the Dashboard, you can add a detailed report with prompts depending on the the header prompt.
This way the detail reports will change based on the header data.
Thank you
Hassan