[OBIEE 11g] OBIEE 11g Export To The File System

OBIEE 11g – Export To The File System

Here’s a script to enable the exporting of content from OBIEE to the Windows file system. 

The principle is quite simple, an Agent is set up in Oracle Delivers and the Delivery Content specified as normal. In this case a whole dashboard page is going to be exported as a PDF.

On the Actions tab we add a new action to Invoke a Server Script.

Click the Edit Parameters (pencil) icon to change the properties. Set the language to VBScript and set the Script Path to be wherever the export script (downloaded from the bottom of this post) has been saved on the OBIEE server.

Finally we must specify 3 parameters for the export script to use: the file to be exported, the desired file and folder names. See the screenshot:

Now each time the Agent is executed it will create a subdirectory (with yyyy-mm-dd format) and within that directory the file will be saved.