Objective:
To
generate multiple excel sheet report from OBIP using data template SQL queries.
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.
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.
develop multiple sheets excel OBIP report using Data template SQL Queries.
Step 1: Create OBIP
report
report
Step 2: Create data template SQL Queries and
place it into data model in OBIP.
place it into data model in OBIP.
Step
3: Data Template SQL Query.
3: Data Template SQL Query.
Step 3: XML
data generation.
data generation.
Step 3: XML data generation.
Output:
(Sheet I)
(Sheet I)
Output:
(Sheet III)
(Sheet III)
By
Karkuvelraja T
Recent Posts