BI Publish an Output File to the File System

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>

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s