• JDELIST is celebrating its 20 year anniversary today!
  • Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Send BI Publisher XML file in an email

jileto

Well Known Member
Has anyone sent (or have an idea) the XML file produced in a BI Publisher Report in an email as an attachment?
Just found this Oracle doc while researching other stuff... https://support.oracle.com/epmos/faces/DocContentDisplay?id=964292.1

You create a XSL template - the document refers to it as an "Identity" XSL. The XSL is coded to produce a copy of the XML as output (something like multiplying a number by 1 produces the same number). Use that XSL template in the report def and set the report def to email the output.

The Oracle document has a sample XSL. I'm pasting it below...

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:eek:utput method="xml" version="1.0" encoding="UTF-8" indent="yes" omit-xml-declaration="no"/>
<!-- Identity template -->
<!-- from http://www.w3.org/TR/xslt section 7.5 -->
<xsl:template match="@*|node()">
<xsl:if test=". != '' or ./@* != ''">
<xsl:copy>
<xsl:apply-templates select="@*|node()"/>
</xsl:copy>
</xsl:if>
</xsl:template>
</xsl:stylesheet>
 
Top