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
  • January 2, 2017 | 22 views