ERP - How to Use OTBI Analysis in BI Publisher

Usecase: Here. We will see how to use OTBI analysis report SQL query in BIP republisher report.

Steps followed:

1. Create OTBI analysis tabular report using Payable Invoices - Transactios Real time subject area. >> select few columns like Invoice Number, Invoice date, Invoice Type Name, Invoice amount, Supplier name >>Advanced tab >> copy SQL issued.
2. Create a data model >> add data set using SQL Query fetched from step1.  Data source is Oracle BI EE>> add a where clause and add P_Supplier_name parameter. >> add alias and display names for all the columns. 
3. Data tab >> view data , we can see parameter tag also showing >> go to properties and deselect "Include Parameter Tags" and select "include empty Tags for Null Elements." Save as sample data
4.  Create report >> select the columns >> customize report >> delete header part >> save >> view report

Detailed screenshots: