nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

Issues in creating dynamic hyperlink and passing parameter from BI Publisher RTF template

Khalil Ferhat

Summary

BI report parameter

Content

Hi,

Would like to pass parameter from BI publisher report to another BI report using hyperlink.

the parameter is called "parc" in the detail report. This is the link that I use :

https://xxxxxxx.com/analytics/saw.dll?bipublisherEntry&Action=open&itemType=.xdo&bipPath=%2FCustom%2FMedz%20Sourcing%2FReportings%2F08%20-%20D%20-%20TB%20Recouvrement%20CA%20SPA.xdo&path=%2Fshared%2FCustom%2FMedz%20Sourcing%2FReportings%2F08%20-%20D%20-%20TB%20Recouvrement%20CA%20SPA.xdo&_paramsparc={/DATA_DS/G_1/PARC}

The value of {/DATA_DS/G_1/PARC} is getting right but the detail report is not taking this value into the query to get the result.

Can anyone help on this plz ?

I'm Using BI Publisher Desktop 12.2.1.2.0

Find more posts tagged with

BI Publisher

BI Publisher Data Models

BI Publisher Report Templates

Comments

Pulkit Kumar Jain

Hi,

Please try to develop The complete link in SQL Code.

For Example, I have one report where I am showing Invoice BU, Supplier Related Data ( Supplier Wise Sum of invoice Amount), and Same I have another detailed report where I am showing complete detail of the Invoice.

In this BIp report When I Click on a particular BU and Supplier Wise Amount, Then it will Automatically pass the BU and Supplier in the Detail report.

Please finds the Below SQL for Passing the Parameter.

( (SELECT external_virtual_host pod_url FROM ask_deployed_domains WHERE deployed_domain_name = 'FADomain') || '/analytics/saw.dll?bipublisherEntry&Action=open&itemType=.xdo&bipPath=%2FCustom%2FPK%20Analysis%2FInvoice%20Detail%20Report.xdo&path=%2Fshared%2FCustom%2FPK%20Analysis%2FInvoice%20Detail%20Report.xdo&bipParams={"_paramsP_LEDGER_NAME":"'||gl.name|| '","_paramsP_BU_NAME":"'||hou.name|| '","_paramsP_SUPPLIER_NAME":"'||ps.vendor_name|| '"}') PROD_URL

In this, I am passing 3 parameters.

1. P_LEDGER_NAME

2. P_BU_NAME

3. P_SUPPLIER_NAME

I give the Same Parameter name in the Detail report.

Please find the Below Code that I used in Interactive Report

https://{/DATA_DS/G_1/PROD_LINK}

Please find the Below Attach Image for Detail.

If anyone wants the Catalog file or detailed Information on this,

Please ping me or mail me at Pulkitj@evosysglobal.com

New Announcements

Upcoming Events

Analytics - Fusion Data Intelligence: CEAL Guidance Office Hours | Americas and Europe
Agenda Presentation: What's New in FDI 26.R3 Open Q & A: Ask your questions of implementation and product specialists Replays of past FDI CEAL Guidance Office Hours are available on Oracle VideoHub here. Fusion Data Intelligence - CEAL Guidance Office Hours The FDI Office Hours are hosted by CEAL solution architects who…
Analytics - Fusion Data Intelligence (FDI) : Overview for Fusion CX Analytics 26.R3 Application Release
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (CX). The session will cover updates on Service, Sales, Marketing & other relevant areas. Presented by: Kausik Misra - Director, CX Product Management, Fusion Data Intelligence…
Analytics - Fusion Data Intelligence: Semantic Model Extensions in FDI: Implementation Patterns, Security, and Best Practices
Build on the foundational concepts from Part 1 with a deeper look at implementation patterns for extending the FDI semantic model. This session covers common use cases such as modifying subject areas, creating custom subject areas, combining external application models, and supporting custom security requirements. It also…