Oracle Analytics Publisher

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

How to config auto run when user click apply button in OAS-Publisher

Received Response
37
Views
4
Comments
User_83P87
User_83P87 Rank 1 - Community Starter
edited Sep 30, 2025 6:32PM in Oracle Analytics Publisher

I’m having an issue: when I open a report on OAS that’s built with an Excel template, it auto-runs right away and downloads the Excel file. I want to configure it so that when I first open it, it won’t run until I choose the parameters, and only when I click apply it should run and download the file.

Answers

  • Sumanth V -Oracle
    Sumanth V -Oracle Rank 8 - Analytics Strategist

    @User_83P87 - Welcome to Oracle Analytics Community!

    It would be helpful if you could share more details about your use case, such as:

    • The version of OAS you are working with
    • Whether it involves a Classic Analysis, DV Workbook, or a BIP/XMLP Report
    • The high-level steps you have taken so far

    This information will help us better understand the scenario and provide more accurate guidance.

    Thanks!

  • BrandonH
    BrandonH Rank 5 - Community Champion
  • User_83P87
    User_83P87 Rank 1 - Community Starter

    Dear @Sumanth V -Oracle

    Thanks for your reply. Here’s my OAS info:

    • OAS version: OAS 2023 (6.4)
    • I’m using BI Publisher with Excel (xls) format, not the high-level steps.

    Really hope to get your support on this.

  • User_83P87
    User_83P87 Rank 1 - Community Starter

    Hi @BrandonH , thanks for getting back to me.
    The issue is if I turn off auto-run, then when I click Apply it doesn’t query any data, it only runs and exports to Excel when I click Export (since I’m using BI Publisher Excel format). What I want is: when I click Apply, the results should show up on screen (like in the screenshot), and the report should only run after user click Apply.

    Untitled.png

    Would really appreciate your help on this 🙏.