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

User_RUIII

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

Gianni Ceresa

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

Hello,

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

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

Thanks

Asim

Gianni Ceresa

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.