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.
by Karkuvelraja Thangamariappan ♠ (@tkarkuvelraja)