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 data-set of SQL queries required to complete the report. Developer has to develop the report with single data-set of SQL query, Instead of using multiple data-set 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)

Comments

Popular posts from this blog

Highlight the cell of Interactive Report based on Search Criteria in Oracle APEX

Querying Data From Flat Files in Oracle

Number of Tables by The Number of Rows in Oracle Database

Save Selected Interactive Grid Records into a Collection - Oracle APEX

Highlight Data That Meet Certain Criteria in Oracle APEX Report

Return a Validation Message using JavaScript if the Oracle Application Express Item is Empty

Remove X (Close Mark) from Oracle APEX Modal Dialog

Display User Rating Icons Dynamically in Oracle APEX Report

Printing Page Numbers in RTF Template [Oracle BI Publisher]

Find Where Specific Table or View is Used in Oracle Database