Password Protect Excel Output in BI Publisher
Password Protect Excel Output in BI Publisher

 1,410 total views

One of the missing piece in BI Publisher earlier was the password protection for Excel 2007 Output and it has been introduced in 18c update.

Earlier password protection was possible for PDF output only and there have been a number of bugs and enhancements pending around the feasibility for password protection for Excel Output. And finally Oracle has worked on this and released this feature in 18c release.

Now, we will look at the steps to enable this feature for BI Reports:

Navigate to Reports and Analytics
Open Catalog
Navigate to BI Report

Once the password is set, click ok and save the report.
Now run the report and download the excel output..
When you open the excel sheet, it will prompt us to enter the password which has been set at the report level.

For now, we cannot create dynamic passwords using the SQL Query added to the data set like we create dynamic password PDF output files.

Hope the dynamic password will also be enabled by Oracle in next releases.

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.

The following two tabs change content below.
Sricharan is a Fusion HCM Solution Architect with over 13+ years of overall experience and 5+ years of Fusion experience. He is passionate about technical aspects of Fusion HCM and writes interesting articles on HCM Extracts, HCM Data Loader, Fast Formula, BI Publisher, Integrations and Automation etc.

This Post Has 3 Comments

  1. Anonymous

    I tried this option, but the output xls file is not prompting for password

  2. Please try again. If it doesn't work please post snapshots of the settings that you have done.

Leave a Reply