Data template in Oracle BI Publisher 10g

Objective:
To
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.
Solution:
To
develop 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 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.

By
Karkuvelraja T

  • January 2, 2017 | 19 views
  • Comments