Sunday, August 9, 2020

BIP Reports linking (Summary and Detail Reports Linking)

Process:

1.     Create 2 BIP Reports with common parameters

2.     Prepare the URL to link the Reports

3.     Place the Hyperlink in Summary Report RTF Template

4.     Attach the Template to Summary Report

5.     Verify the Results

 

Step 1: Create 2 BIP Reports with common parameters

Summary Report


Create Detail Report Parameters with Type as Text


 

Step 2: Prepare the URL to link the Reports

Navigate to Detail Report from xmlpserver


 

Copy the Current Page URL. it will look something like below URL with all the parameters of the Report

https://<hostname>/xmlpserver/<ReportDirectory>/<ReportName>.xdo?xiasynch=&_xpf=&_xpt=0&_dFlag=false&_edIndex=0&_dIndex=0&_rToken=&_ranDiag=false&_xdo<ReportDirectory>/<ReportName>.xdo&_xmode=

&_paramsp_legal_entity=

&_paramsp_cust_from=

&_paramsp_cust_to=

&_paramsp_as_of_date=

&_paramsp_amount_due_from=

&_paramsp_amount_due_to=

&_xt=Customer%20Aging%20Report&_xf=excel&_linkToReport=true

(Check the Reference section to identify each parameter usage)

 

Modify the URL to pass the Parameters from the Summary Report to Detail Report

 

https://<hostname>/xmlpserver/<ReportDirectory>/<ReportName>.xdo?xiasynch=&_xpf=&_xpt=0&_dFlag=false&_edIndex=0&_dIndex=0&_rToken=&_ranDiag=false&_xdo<ReportDirectory>/<ReportName>.xdo&_xmode=

&_paramsp_legal_entity={DATA_DS/P_LEGAL_ENTITY}

&_paramsp_cust_from={DATA_DS/P_CUST_FROM}

&_paramsp_cust_to={DATA_DS/P_CUST_TO}

&_paramsp_as_of_date={DATA_DS/G_3/AS_OF_DATE}

&_paramsp_amount_due_from={DATA_DS/P_AMOUNT_DUE_FROM}

&_paramsp_amount_due_to={DATA_DS/P_AMOUNT_DUE_TO}

&_xt=Customer%20Aging%20Report&_xf=excel&_linkToReport=true

Tip: While passing the Date parameter convert it to DD-MON-YYYY format

 

In order to generate the Host URL Dynamically and to reuse the same Template in different instances

We can use the pre-defined BI Publisher’s variable called ‘CURRENT_SERVER_URL’, which returns a URL that contains hostname, port number, and the root path.

So now we can replace the URL to something like below

{$CURRENT_SERVER_URL}/ReportDirectory/ReportName.xdo + parameters

 

Step 3: Place the Hyperlink in Summary Report RTF Template

In order to use the ‘CURRENT_SERVER_URL’ variable we need to declare it in the RTF template first.

<?param@begin:CURRENT_SERVER_URL?>

Then Use the MS Word’s Hyper link option to insert the link prepared in Step 2


 

Step 4: Attach the Template to Summary Report

Upload the RTF template and set the Report Properties to open the Detail Report in New window


 

Step 5: Verify the Results

Provide the parameter values and click on Apply


Click on the Detail Report Hyper link, Summary page parameters will be copied to the detail Report page as shown


Common Mistakes:

1.     While Entering URL, ensure it is in single line with no spaces in between

Correct:

https://<hostname>/xmlpserver/<ReportDirectory>/<ReportName>.xdo?xiasynch=&_xmode=&_paramsp_legal_entity=&_xt=Customer%20Aging%20Report&_xf=excel&_linkToReport=true

Incorrect:

https://<hostname>/xmlpserver/<ReportDirectory>/<ReportName>.xdo?xiasynch=&_xmode=

&_paramsp_legal_entity=

&_xt=Customer%20Aging%20Report&_xf=excel&_linkToReport=true

 

2.      Enter the correct path for the parameters.

Tip: Refer to the hierarchy displayed under the Data Model structure section to identify the correct path


Correct:

https://<hostname>/xmlpserver/<ReportDirectory>/<ReportName>.xdo?xiasynch=&_xmode=&_paramsp_legal_entity={DATA_DS/G_3/AS_OF_DATE}&_xt=Customer%20Aging%20Report&_xf=excel&_linkToReport=true

Incorrect:

https://<hostname>/xmlpserver/<ReportDirectory>/<ReportName>.xdo?xiasynch=&_xmode=&_paramsp_legal_entity={/G_3/AS_OF_DATE}&_xt=Customer%20Aging%20Report&_xf=excel&_linkToReport=true

 

Reference:

To check the Current Page URL Parameter Usages:

https://docs.oracle.com/cd/E80149_01/bip/BIPRD/GUID-F788B306-99F6-432E-BCD5-F45046D31684.htm#BIPRD3321

No comments:

Post a Comment