Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Password Protect Scheduled OTBI Excel Analysis

269
Views
11
Comments
Gary Miller-39965
Gary Miller-39965 Rank 3 - Community Apprentice
in Oracle Transactional Business Intelligence

Summary

Question on whether it's possible to add a password to OTBI output

Content

Hi,

I'm looking to add a password to the output produced by OTBI Analysis (excel format) where we use an agent to run the report and deliver to recipients email inboxes.

I'm unsure if this is possible / if so how to do it - does anyone know?  Have seen some questions/articles which are dated - it previously wasn't possible - so things may have changed since.

Many Thanks

Gary

Tagged:
«1

Comments

  • AshishERPCloud
    AshishERPCloud Rank 5 - Community Champion

    A PDF Output can be password protected for sure.

    Need to check if this can be done in Excel too.

    You may refer links (for PDF Password protected file in links below)

    Dynamic password : https://apps2fusion.com/oracle-fusion-online-training/fusion-applications/fusion-payroll/1776-dynamic-password-protected-in-oracle-hcm-cloud-application

    Static Password: https://apps2fusion.com/oracle-fusion-online-training/fusion-applications/fusion-payroll/1580-creating-a-password-protected-pdf-output-in-oracle-fusion-cloud-application

    Kind Regards

    Ashish

  • Gary Miller-39965
    Gary Miller-39965 Rank 3 - Community Apprentice

    Thanks for the quick reply Ashish. I've had a look at the instructions but haven't found a way to do it on excel.  At the steps below I don't have an option to navigate to a "formatting tab".  Though I didn't change the default format of the report to PDF which you note in the previous step.

    If you find a way to do it please let me know.

    Many thanks

    Gary

    For this we need to perform the below steps:

    1. Click on Edit Report

     

    1. Click on ‘Properties’ button

     

    1. Navigate to Formatting Tab

  • rashid ramzan-45341
    rashid ramzan-45341 Rank 1 - Community Starter

    You cannot Password Protect Excel output in BI Publisher as there is no option provided by oracle. I have used PDFs with password protection, which you can configure by following Ashish's instructions above. 

    There was an enhancement request to make this available in BI Publisher but don't think it is delivered but you can check with oracle support.

    If you are trying to do this in OTBI Analysis and not the publisher side then password protection is not supported.

    Thanks

    Regards,

    Rashid

  • Gary Miller-39965
    Gary Miller-39965 Rank 3 - Community Apprentice

    Thanks Rashid - I will follow up with support on the enhancement request.

    Best Regards

    Gary

  • Sanjay Chaurasia-28291
    Sanjay Chaurasia-28291 Rank 1 - Community Starter

    Have this enhancement request completion has any ETA?

     

    Thanks and regards

    Sanjay

  • Alvaro Couto
    Alvaro Couto Rank 4 - Community Specialist

    Hello Guys,

    Any ETA for the enhancement request to protect Excel outputs with password?

    Thank you,

    Alvaro Couto

  • Gary Miller-39965
    Gary Miller-39965 Rank 3 - Community Apprentice

    Hi, we would also appreciate an ETA.

    Thanks

    Gary Miller

  • Julian Challenger-Oracle
    Julian Challenger-Oracle Rank 6 - Analytics Lead

    Moved to correct forum to elicit a response.

  • Gangi Reddy Madatala-143642
    Gangi Reddy Madatala-143642 Rank 1 - Community Starter


    On the Report Properties > Formatting tab, there are now Password fields for Docx, pptx and xlsx as the technote suggests. 
    There is nothing to be done to enable the protection itself.

    The user needs to modify the report properties to add a password for any/all of these outputs.
     

    See attached screen shot for example, a password was added for the docx output:

    Report Properties

     

    Regards

    Gangi reddy

  • Gary Miller-39965
    Gary Miller-39965 Rank 3 - Community Apprentice

    Hi Gangi,

     

    Thanks for the update.  This functionality looks to be for BI Publisher reports only.  Is it available / planned to be made available for OTBI Analysis which are scheduled via Agents?

     

    Thanks

    Gary