Oracle Analytics Publisher

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Publisher

Categories

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
66
Views
6
Comments
hoangth1118
hoangth1118 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.

Tagged:

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
    image.png
  • hoangth1118
    hoangth1118 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.

  • hoangth1118
    hoangth1118 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 🙏.

  • BrandonH
    BrandonH Rank 5 - Community Champion

    If you want the visual, use an analysis/dashboard?

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

    Hi @ hoangth1118

    This is an expected as you are using Excel Template . You can try RTF template so you can able to see the data if required you can able to download to excel format.

    Regards,

    Arjun