Oracle Transactional Business Intelligence

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

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

366
Views
1
Comments

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

Comments

  • Pulkit Kumar Jain
    Pulkit Kumar Jain Rank 3 - Community Apprentice

    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