Posts

Showing posts from January, 2016

Split by count excel report in Oracle BI Publisher 10g

Image
Objective : To create a template to split records in excel sheet in Oracle BI Publisher 10g. Solution : Template Creation - EXCEL Step 1:  Open the Excel. (See below image) Step 2:  Go to Formulas => Name Manager – See the XDO call Step 3:  Go to Sheet2 (XDO_METADATA) – See the XSLT code Step 4:  Come to Sheet1 – See how the groupings were done Step 5:  Create one XML file – with the below code, see how the sheet were split by count of records using XML <?xml version="1.0" encoding="utf-8" ?> <xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:template match="/"> <ROWSET> <xsl:variable name="var_size" select="50000" /> <xsl:for-each select="/ROWSET/ROW"> <xsl:variable name="var_pos" select="position()" /> <xsl:variable name="var_mod&quo