How to schedule a job in OBIEE to export a report to excel/csv ? — Oracle Analytics

Oracle Analytics Cloud and Server

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

Categories

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

How to schedule a job in OBIEE to export a report to excel/csv ?

Received Response
104
Views
3
Comments
User_RUIII
User_RUIII Rank 3 - Community Apprentice
edited Aug 13, 2024 6:08PM in Oracle Analytics Cloud and Server

Dear all,

May I know whether I can schedule a job in OBIEE to export a report to excel/csv ? Or OBIEE won't provide a direct way to do so. I have to write a EJB by myself ?

Thanks in advance

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    By "export" you mean save the file on the filesystem?

    If that's the "export" you look for you are right looking in the EJB direction, OBIEE itself can schedule execution of analysis with agents, but an agent generally deliver a notification on screen (in the OBIEE home or where you add the right view in your dashboards) or by email. So to save content to the filesystem you need an EJB you call via an action.

    Plan B is to look at Publisher as it has more delivery options available.

  • asim cholas
    asim cholas Rank 6 - Analytics Lead

    Hello,

    You can use java script to achieve the same. Create a script like below and keep it in your server

    Capture.PNG

    Then go to agent advanced tab and use the script file there.

    Capture.PNG

    Thanks

    Asim

  • Gianni Ceresa
    Gianni Ceresa Mod

    Just a detail: the javascript way only work on a Windows Server !

    As the OP don't provide a single information ( ) it's impossible to know which OS his server uses. EJB will work in both Windows and Linux/Unix OS.