Wednesday, March 23, 2022

ERP - Create a BI report text output using XSL template


Here, we will create a text Output BI report using XSL template. 

Why we should use xsl template?

  • XSL Stylesheet is generally used to generate text, xml, html and FO.
  • Rich in xslt function like format-number(), count(), sum() etc.
  • user friendly syntax in xml format.

.xsl template:

<?xml version="1.0" encoding="utf-8"?>

<xsl:stylesheet version="2.0"





<xsl:output method="text" omit-xml-declaration="yes" indent="no"/>

<xsl:template match="/">













<xsl:for-each select="DATA_DS/G_1">

<xsl:value-of select="SUPPLIER_NAME"/>


<xsl:value-of select="SUPPLIER_NUMBER"/>


<xsl:value-of select="SUPPLIER_ID"/>


<xsl:value-of select="COUNTRY"/>


<xsl:value-of select="CITY"/>

<xsl:value-of select="STATUS"/>





Data model query used:

Select hp.party_name supplier_name,

poz.segment1 supplier_number,

poz.vendor_id supplier_id,



from POZ_SUPPLIERS poz, HZ_PARTIES hp where 1=1 

And poz.party_id = hp.party_id

And rownum<=10

Detailed steps with Screenshots:

No comments:

Post a Comment

Featured Post

11g to 12c OSB projects migration points

1. Export 11g OSB code and import in 12c Jdeveloper. Steps to import OSB project in Jdeveloper:   File⇾Import⇾Service Bus Resources⇾ Se...