OTBI - How to create Drill Down with custom data model reports

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

Riyaz Ali-Oracle

Hi,

You can create a hyperlink in the first report (Project) that passes parameters (like Project ID) to the second report (Cost per Project).

Steps you can try:

1. Enable Parameters in the Target Report
   In the Cost Report, define Project ID as a report parameter.
   Make sure it accepts values passed via URL.
2. Construct the Drill-Down URL
   In the Project Report, embed a hyperlink like this:

<a href="https://<FusionHost>/xmlpserver/CostReport.xdo?_xdoFullPath=/Custom/CostReport.xdo&_xdoTemplate=CostTemplate&_xdoReportType=xml&_xdoParamName=ProjectID&_xdoParamValue=12345">View Cost</a>

Replace:

<FusionHost> with your Fusion Cloud host URL
CostReport.xdo with the full path of your target report
ProjectID with the actual parameter name
12345 with the dynamic value from your data model
You can use BI Publisher’s <?xdofx:?> syntax to dynamically insert the Project ID:

<a href="https://<FusionHost>/xmlpserver/CostReport.xdo?_xdoParamValue=<?xdofx:Project_ID?>">View Cost</a>

3. Embed the Link in RTF or Excel Template
In RTF: Use FORMFIELD or HYPERLINK tags
In Excel: Use HYPERLINK() formula with dynamic cell values

Please check below:

Drill down in fusion BIP Reports — Cloud Customer Connect

Thanks,
Riyaz Ali