Tuesday, December 13, 2022

ERP BI REPORT - XSLT vs BIP Tags | BI publishers

XSLT vs BIP Tags:

  • Simple BI Publisher RTF template can be developed with BIP tags. BIP Tags are easier to use even who does not have XML or XSLT experience.
  • Behind the scene, BIP tags are translated to XSL code at runtime.
  • To develop rich functionality such as Charts, Graps XSLT is used, wizards can be used to define simple charts and graps but to customize the only option is XSLT coding.
  • XSLT and BIP Tags can co-exist in the RTF template. Custom functions can be created in XSL template and can be invoked from RTF template.
Example of XSL :
<OrderNum>
  <xsl:value-of select="/Data_DS/G_1/Order_Number"/>
</OrderNum>

<xsl:for-each select="DATA_DS/G_1">
  <SalesOrder>
    <OrderNum>
      <xsl:value-of select="Order_Number"/>
    </OrderNum>
  </SalesOrder>
</xsl:for-each>


Example of BIP tags :
<OrderNum>
  <?/Data_DS/G_1/Order_Number?>
</OrderNum>

<?for-each select="DATA_DS/G_1"?>
  <SalesOrder>
    <OrderNum>
      <?Order_Number?>
    </OrderNum>
  </SalesOrder>
<?end for-each?>








No comments:

Post a Comment

Featured Post

OIC - Source File Validation Using Stage File and Throw New Fault in OIC

Source File Validation Using Stage File and Throw New Fault in OIC Use Case In Oracle Integration Cloud (OIC), validating the source file ...