Showing posts from September, 2016

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. S tep 3:  XML data generation. S tep 3:  XML data generation. Output: (Sheet I) Output: (Sheet III)