In most of the cases, Employees will not have access to Reports and Analytics to access the reports. However if there is a requirement to create a report and provide access to employees, giving access to Reports and Analytics might expose other reports or seeded reports too, hence it is not a wise decision to provide access to BI Catalog.
We can develop the report and add the report hyperlink to the Navigator or Springboard and then give access to Employee role. In this way we are only exposing the single report and the employees will not have access to BI Catalog. However while exposing the hyperlink, we need to ensure we pass the right parameters in order to get it done correctly.. If we copy the report hyperlink directly and put it on navigator, when the employees open the report, they would see the catalog and they can access other reports too if they have data access.
Below is the syntax for the hyperlink that needs to be added to the Navigator:
‘https://abcd-dev2.fa.us6.oraclecloud.com:443/xmlpserver/Custom/Human%20Capital%20Management/Benefits/Sample%20Report.xdo?
_xpf=
&_xpt=1
&_xdo=%2FCustom%2FHuman%20Capital%20Management%2FBenefits%2FSample%20Report.xdo
&_xmode=4
&_paramsp_asg_num=#{bindings.AssignmentNumber.inputValue}
&_xt=Sample
&_xf=html
&_xautorun=true
Description of flags:
_xpf – for internal use – we can leave it as-is.
_xpt – defines whether the report output should be rendered in the full XMLP window. Use a value of 0 or a 1 for just the document itself.
_xdo – this provides the path to the current report, its optional so you can leave it out.
p_asg_num – this is a parameter value for the report, in this case the assignemnt for the data. Of course you can have multiple parameters and their values on the URL
_xt – this controls the template to be used, this is the template name i.e. Standard not the template file name.
_xf – this controls the format of the output to be generated e.g. PDF, HTML, etc
_xautorun – If true, the report is auto run and the o/p is shown
So, when you have a requirement to have report on navigator, you can use this approach and add the report directly.
If you have any questions, please feel free to reach out to me by posting in comments section.
If you are interested in learning Fusion Technical tools go through this post
If you liked the article, please share it with your friends/ colleagues/ teammates or anyone who might also benefit from it.
Hi Sricharan,
This is helpful information. I have provide the static link while creating the page entry
https://abcd-dev2.fa.us6.oraclecloud.com:443/xmlpserver/Custom/Human Capital Management/Benefits/Sample Report.xdo?
But getting error page can not be displayed. How to xpf, xpt etc..that you have explained above. Please let me know. Thanks!
Hi GK,
Please use frame the link like below, use %20 instead of spaces in the hyperlink.. I will correct the main post:
https://abcd-test.fa.us6.oraclecloud.com:443/xmlpserver/Custom/Human%20Capital%20Management/Payroll/Custom%20Report/Master_Rpt.xdo?_xpt=0&_xmode=2&_xautorun=true
Thanks,
Sricharan
Thanks Sricharan for quick response. Now I am trying below URL
https://ekgz-dev1.fa.us6.oraclecloud.com/xmlpserver/Custom/Human%20Capital%20Management/Mohan/FDII_Pending_Approvals.xdo?_xpt=0&_xmode=2&_xautorun=true
But getting error "Unauthorized Access: please contact the administrator."
I habe all the required role.
Can you please check if you are able to access this report using the link below?
https://ekgz-dev1.fa.us6.oraclecloud.com/xmlpserver/Custom/Human%20Capital%20Management/Mohan/FDII_Pending_Approvals.xdo
If not there is some issue with the roles. You should atleast have the BI Consumer role/BI Admin role to access these links.
Thanks,
Sricharan
Works!