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 you need your ex-girlfriend or ex-boyfriend to come crawling back to you on their knees (no matter why you broke up) you must watch this video
    right away...

    (VIDEO) Get your ex back with TEXT messages?

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

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

    ReplyDelete
  4. 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
  5. Nice Blog..XML and provides formal XML schemas for business transactions.
    cXML Ariba

    ReplyDelete