Skip to main content

Posts

Showing posts from October, 2016

Multiple sheet excel report template generation in Oracle BI Publisher 10g

Objective : To create template for generating multiple sheet excel in Oracle BI Publisher 10g. Solution : Template Creation - EXCEL Step 1:  Excel contains the below template with Sheet 1 and 2 as follows 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 Note:   Ø    Workout example screenshot shared below.   Ø    Template has been attached separately with this component. Output:  Output will be multiple sheets.