Objective:
To
generate reports from OBIP using data template SQL queries.
generate reports from OBIP using data template SQL queries.
Scenario:
Customer
has given a requirement to develop the report in OBIP. While developing it,
developer came to know two dataset of SQL queries required to complete the
report. Developer has to develop the report with single dataset of SQL query,
Instead of using two dataset of SQL queries.
has given a requirement to develop the report in OBIP. While developing it,
developer came to know two dataset of SQL queries required to complete the
report. Developer has to develop the report with single dataset of SQL query,
Instead of using two dataset of SQL queries.
Solution:
To
develop OBIP report using Data template SQL Queries.
develop 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.
Step 4: XML data generation.
Step 5: Excel Template.
Note: By this
method, we can call package or procedure inside the dataset. It will reduce no. of dataset use in it.
method, we can call package or procedure inside the dataset. It will reduce no. of dataset use in it.
By
Karkuvelraja T
Recent Posts