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 - "Dynamically Configuring Relative URLs for REST API Invocations in Oracle Integration Cloud" | Dynamically invoke local integration

Use Case: In Oracle Integration Cloud (OIC), there is often a need to dynamically determine the Relative URI while invoking REST APIs. This ...