Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Bursting BI publisher report with Excel file or creating each record as one report from in excel dat

Received Response
1047
Views
14
Comments
2»

Answers

  • mist123
    mist123 Rank 4 - Community Specialist

    Please read this blog and let me know and try and try then ask me questions so that you will know ...:)

    10 Simple steps for XML Bursting

  • mist123
    mist123 Rank 4 - Community Specialist
    what kind of delivery you want PDF to folder, Burst to Email , printer?<?xml version="1.0" encoding="UTF-8"?><xapi:requestset xmlns:xapi="http://xmlns.oracle.com/oxp/xapi" type="bursting">    <xapi:request select="/DATA_DS/G_1">    <xapi:delivery>     <xapi:filesystem id="pdftofolder" output="/tmp/$EMPID_${EMP_ID}_XXX_${ADDRESS}.pdf" />    </xapi:delivery>    <xapi:document output-type="pdf" delivery="pdftofolder">      <xapi:template type="rtf" locale="en-US" location="xdo://XXC.XXARNEWXML_BUR.en.US/?getSource=true"  --> change with ur Template code  filter=".//G_INVOICE[CF_BURST='Y' and CF_ORGNAME='US']"/>  ---If you have any filters?? otherwise remove this</xapi:document>     </xapi:request></xapi:requestset>
  • usersrekan
    usersrekan Rank 5 - Community Champion

    No we are not using EBS. is there any other way where we can generate each record as report wit excel data file datamodel?

  • mist123
    mist123 Rank 4 - Community Specialist

    you doing EBS bi publisher correct ? then follow my link...the one which i provide example is the sample.