Oracle Business Intelligence Publisher is an enterprise reporting solution to author, manage and deliver all types of highly formatted documents. It is used as a key component in Oracle BI Enterprise, Oracle OTBI and also Oracle Analytic Cloud. Bi Publisher can query data from multiple data sources, has a flexible layout designer and allows for the scheduling of reports in multiple output formats to multiple delivery destinations. Our “hands on” workshop course, run at your premises, allows you to learn by example. Our trainers are expert consultants with “real world” experience and all exercises can be customised using an extract of “your” sample data helping you put theory into practice.
Objectives
- Overview of BI Publisher 12c components and architecture
- Create reports with parameters and lists of values
- Create data sets from multiple data sources
- Create reports based on Physical SQL from a database
- Create reports based on Logical SQL from BI Analytics /BI Server
- Create layout templates
- Insert a Table and Chart. Understand groups and place holders
- Create Headers and Footers. Add page numbers and page breaks
- Format Numbers and Dates. Use conditional formatting
- Add totals and group sub totals. Use variables for running totals
- Deliver to multiple destinations
- Configure scheduler then schedule reports for delivery
- Manage schedule history
- Burst to File or Email (Query once, deliver multiple formats, multiple destinations)
- Create pivot tables