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