Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Accepted answer
15
Views
2
Comments
Christian Flegler
Christian Flegler Rank 1 - Community Starter
edited Sep 9, 2025 4:13PM in Oracle Transactional Business Intelligence

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

Tagged:

Best Answer

  • Hassan El Bouihi-Oracle
    Hassan El Bouihi-Oracle Rank 6 - Analytics Lead
    Answer ✓

    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

Answers

  • Riyaz Ali-Oracle
    Riyaz Ali-Oracle Rank 6 - Analytics Lead
    edited 4:23AM

    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