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

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 [email protected]