11 Replies Latest reply on Jul 6, 2017 6:13 AM by Christian Berg

    Access to download .iqy file in Oracle BI Interactive Dashboards

    Dulce Bautista

      (Please let me know if I should be posting in another forum.)

       

      When trying to download the .iqy file for a Dashboard, it says that I am not authorized.  Is there a way to grant this access?

       

      STEPS TO REPRODUCE:

      1. Log into Oracle Business Intelligence.
      2. On Home Page-->Recent, select Edit for one of the dashboards.
      3. Select Advanced tab.
      4. In the Referencing the Results section, select the 2nd link to download the iqy Web Query file.
      5. When prompted, save the file locally and attempt to open it.
      6. When opening, it launches Microsoft Excel along with a message "Microsoft Office has identified a potential security concern.  Data Connections have been blocked. If you choose to enable data connections, your computer may no longer be secure.  Do not enable this content unless you trust the source of this file."
      7. Select the Enable button.
      8. Enter login information at the prompt for Oracle BI User.
      9. The spreadsheet then displays with the following information:  "You are not currently authorized to use Oracle BI Interactive Dashboards.If you would like to use this powerful capability, please contact this site's administrator."