What is BI Publisher?
What is BI Publisher?
Its a component of OBIEE (Oracle Business Intelligence Enterprise Edition) where a developer can create a layout (just the layout) for complex-layout report.
Examples:
The following report has two totals at the bottom. This is simple, why to use BI publisher for it? Well, its just an example of Row-level columns. Report can have All Concomitant drugs separated by comma (,) as a row level column.
So, create a layout in Microsoft word.
Bring the layout in to OBIEE
Integrate a report in to BI layout.
| Reporttype | Caseno | Initialreceiptdate | Age | Ageunit | Gender | Prodname | Drugtype | Patid |
| G V IFREPORTTYPERS | F CASENO | INITIALRECEIPTDATE | AGE | AGEUNIT | GENDER | PRODNAME | DRUGTYPE | PATID E |
| Total by Report Type REPORTTYPE is CASENO E | ||||||||
| Grand total CASENO | ||||||||