1. Access to BI Report.
2. Access to create and publish Sandbox.
Process:
1. Get the report URL.
2. Create a publishable sandbox.
3. Create page entity (Hyperlink) and provide the report URL as Destination
4. Publish the sandbox.
5. Verify the results.
Example: Calling supplier Report on supplier page by passing supplier ID
Step 1: Get the report URL.
Navigate to the xmlpserver and open the BI report for which we need to create a hyperlink on Oracle page.
Click on Settings icon and Share the report link for the current page as shown below
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=<ReportName>.xdo&_xmode=&xdo%3Axdo%3A_paramsp_vendor_id_div_input=All
&_paramsp_vendor_id=
&_xt=output&_xf=pdf&_xautorun=true&_linkToReport=true
(In step 2, we will see on how to get the parameter value, as it requires creating sandbox)
Step 2: Create a publishable sandbox.
Navigate to Sandboxes under Configuration.
Click Create Sandbox button. Enter the Sandbox name, Description.
Ensure to select Page Composer tool. And click on Create and Enter.
The Sandbox has been created. Go to Home.
Navigate to the required Oracle page on which Hyperlink needs to be added.
Ex: Procurement >> Suppliers >> Manage Suppliers (Query a supplier)
Click on User icon dropdown and Click on Edit page.
To get Parameter Value:
Go to Structure tab and select any field on the page and edit it as shown below
And Navigate to the field and edit the label as shown
Select Expression Builder from drop down and edit the expression as shown
(Select Binding Params and select the field you want to pass as the parameter)
Copy the expression and paste it in the URL Created in step 1 as shown below
https://<hostname>/xmlpserver/<ReportDirectory>/<ReportName>.xdo?_xiasynch=&_xpf=&_xpt=0&_dFlag=false&_edIndex=0&_dIndex=0&_rToken=&_ranDiag=false&_xdo=<ReportName>.xdo&_xmode=&xdo%3Axdo%3A_paramsp_vendor_id_div_input=All
&_paramsp_vendor_id=#{bindings.VendorId.inputValue}
&_xt=output&_xf=pdf&_xautorun=true&_linkToReport=true
Step 3: Create page entity (Hyperlink) and provide the report URL as Destination
From the structure tab , select the area on which a new link needs to be added. Click on the (+) button to add a new component.
Select Components and click on Open.
Click on Add on Hyperlink. And click on Close.
Optionally, select the region to re-order the child components.
Re-order the child components in Child Components tab. uncheck the checkboxes that are not to be displayed. Click Apply and OK.
After the rearrangement, it looks like below:
Expand the region in the dock and select the element that is newly added. Eg: showDetailFrame> Hyperlink. Click on Edit.
Under the Secured Token tab, enter the report URL retrieved in Step1 to the Destination field. Click Apply and OK.
Go to the Display options. To change the text, click on Override.
Click on Expression Builder.
Enter the text you want to display on the page. Click OK.
Note: Optionally, we can restrict the display of this newly added component based on user roles/ explicit conditions. For that, we need to override the Show Component Field and provide an EL expression to display based on roles or explicitly provide the conditions to show/ hide the component.
Click on Close.
Step 4: Publish the sandbox
Click on the Sandbox name on the top left and select Publish.
Click OK.
Click Publish.
A warning message appears. Click Continue to Publish.
Step 5: Verify the results.
Navigate to the Oracle page on which new hyperlink has been added.
Ex: Procurement >> Suppliers >> Manage Suppliers (Query a supplier). A Hyperlink appears as below.
On clicking the hyperlink, it navigates to the BIP report by passing supplier id value to the backend as parameter.
This completes the addition of a hyperlink to the BI report on the oracle applications page.
No comments:
Post a Comment