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.
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.
|G V IFREPORTTYPERS||F CASENO||INITIALRECEIPTDATE||AGE||AGEUNIT||GENDER||PRODNAME||DRUGTYPE||PATID E|
|Total by Report Type REPORTTYPE is CASENO E|
|Grand total CASENO|