Use a bursting control file attached to the BI Publisher Data Definition.
For example:
<?xml version="1.0" encoding="UTF-8" ?> <!-- --> <!-- ######################################################################################### --> <!-- Application : XX General Ledger --> <!-- Module : C4GL075 --> <!-- Author : David Taylor --> <!-- Date : 03-FEB-2011 --> <!-- Description : XML Publisher Bursting Control File to publish a HYPERION data extract, in --> <!-- MS Excel format, to the directory /erp/FTP/HYPERION/out --> <!-- --> <!-- Modification History --> <!-- ==================== --> <!-- Date Name Ver Comments --> <!-- =========== ================ === ===================================================== --> <!-- 03-FEB-2011 David Taylor 1.0 Created. --> <!-- --> <!-- ######################################################################################### --> <!-- --> <xapi:requestset xmlns:xapi="http://xmlns.oracle.com/oxp/xapi"> <xapi:request select="/XXGL075/FILESET"> <xapi:delivery> <xapi:filesystem id="file1" output="/erp/FTP/HYPERION/out/HSP_TEXT_CELL_VALUE.xls" /> </xapi:delivery> <xapi:document output-type="excel" delivery="file1" > <xapi:template type="xsl-fo" location="xdo://XXGL.C4GL075.en.00" /> </xapi:document> <xapi:delivery> <xapi:filesystem id="file2" output="/erp/FTP/HYPERION/out/archive/HSP_TEXT_CELL_VALUE.xls.${REQUEST_ID}" /> </xapi:delivery> <xapi:document output-type="excel" delivery="file2" > <xapi:template type="xsl-fo" location="xdo://XXGL.XXGL075.en.00" /> </xapi:document> </xapi:request> </xapi:requestset>