Monday 2 January 2017

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 Sheet1 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 T

7 comments:

  1. If we have multiple columns to take sum of in the same sheet, How shall we write the metadata sheet. Please suggest

    ReplyDelete
  2. Nice blog about punchout XML, it's being great to read this.
    CXML Punchout

    ReplyDelete
  3. cXML PunchOut - Commerce extensible markup language application who is a protocol created by Ariba used to communicate between sessions across the internet.
    Commerce Extensible Markup Language Punchout

    ReplyDelete
  4. Nice Blog..XML and provides formal XML schemas for business transactions.
    cXML Ariba

    ReplyDelete
  5. I have two query dm1 and dm2
    dm1 in to excel Sheet1 and dm2 in excel Sheet2
    but rows 65000+ XOD_Sheet dont help me...
    how cane i solve this????

    ReplyDelete
  6. I feel really happy to have seen your webpage and look forward to so many more entertaining times reading here.Same as your blog i found another one Oracle Fusion HCM .Actually I was looking for the same information on internet for Oracle Fusion HCM and came across your blog. I am impressed by the information that you have on this blog. Thanks once more for all the details.

    ReplyDelete