Monday 2 January 2017

Multiple sheet excel report in Oracle BI Publisher 10g using data template SQL Query


Objective:

To generate multiple excel sheet report from OBIP using data template SQL queries.

Scenario:

Customer needs multiple sheets excel report from OBIP. While developing it, developer came to know multiple dataset of SQL queries required to complete the report. Developer has to develop the report with single dataset of SQL query, Instead of using multiple dataset of SQL queries.

Solution:

To develop multiple sheets excel OBIP report using Data template SQL Queries.


Step 1: Create OBIP report


Step 2:  Create data template SQL Queries and place it into data model in OBIP.



Step 3: Data Template SQL Query.









Step 3: XML data generation.




Step 3: XML data generation.



Output: (Sheet I)



Output: (Sheet III)




By 
Karkuvelraja T

2 comments:

  1. It's interesting to read blog about punchout cxml.
    Punchout CXML

    ReplyDelete
  2. İf i have 2 queries so queries 65k+
    what to do then?
    XDO_SHEET_? don't help.

    ReplyDelete