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)
by Karkuvelraja Thangamariappan ♠ (@tkarkuvelraja)