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:
No comments:
Post a Comment