Use a bursting control file attached to the BI Publisher Data Definition.
For example:
<?xml version="1.0" encoding="UTF-8" ?>
<!-- -->
<!-- ######################################################################################### -->
<!-- Application : General Ledger -->
<!-- Module : GL004 -->
<!-- Author : David Taylor -->
<!-- Date : 07-NOV-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 R12 version created, based on GL075 v1.0 -->
<!-- 27-FEB-2015 David Taylor 2.0 Changed xsl-fo to xslfo following 12c dbase upgrade -->
<!-- -->
<!-- ######################################################################################### -->
<!-- -->
<xapi:requestset xmlns:xapi="http://xmlns.oracle.com/oxp/xapi">
<xapi:request select="/C4GL004/FILESET">
<xapi:delivery>
<xapi:filesystem id="file1" output="${OUT_DIR}/HSP_TEXT_CELL_VALUE.xls" />
</xapi:delivery>
<xapi:document output-type="excel" delivery="file1" >
<xapi:template type="xslfo" location="xdo://C4GL.C4GL004_01.en.00" />
</xapi:document>
<xapi:delivery>
<xapi:filesystem id="file2" output="${OUT_ARCH_DIR}/HSP_TEXT_CELL_VALUE.xls.${REQUEST_ID}" />
</xapi:delivery>
<xapi:document output-type="excel" delivery="file2" >
<xapi:template type="xslfo" location="xdo://C4GL.C4GL004_01.en.00" />
</xapi:document>
</xapi:request>
</xapi:requestset>
theclickspace 