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

3 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