Categories
- All Categories
- 150 Oracle Analytics News
- 28 Oracle Analytics Videos
- 14.7K Oracle Analytics Forums
- 5.7K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 54 Oracle Analytics Trainings
- 12 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
Issues in creating dynamic hyperlink and passing parameter from BI Publisher RTF template

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 :
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
Comments
-
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
0