OVERVIEW
This two day course provides your team with all the skills they will need to produce professional-looking reports using this latest Oracle reporting tool. In addition to developing reports using Oracle BI Publisher either standalone or as part of Oracle Business Intelligence Enterprise Edition, students will learn how to administer BI Publisher. Aimed at developers and users wishing to make use of Oracle’s “pixel-perfect” reporting and publishing tool, it covers the creation of simple and advanced report templates, creation of data queries against both relational, web service and OLAP data, security, and integration with Oracle Business Intelligence Enterprise Edition. With a workshop style, there are many opportunities for students to practice thru computer workshops with sample data.
DURATION: 2 Days
Topics covered in this course include:
- Understanding the BI Publisher Architecture
- Understanding XML and the X standards
- Viewing and Scheduling Reports
- Creating Simple Reports
- Parameters and Lists of Values
- Data Templates
- Advanced Template Features
- Extending the BI Publisher Template
- Scheduling Reports
- Security
- Excel and the Online Analyzer
- Reports with Multiple Datasources
- BI Publisher Administration
- Integration with OBIEE
INTENDED AUDIENCE
This course is designed for Business Analysts and Reports Developer who will be using Oracle BI Publisher to present their business data.
PREREQUISITES
Solid understanding of Relational and Dimensional Databases and SQL and has completed the OBIEE Create Reports and Dashboards class or equivalent work experience.
FORMAT/MATERIALS
This course includes a combination of lecture, discussion and numerous computer workshops. Students will receive an extensive course manual covering the topics presented in class, which will be a valuable reference after class.
CONTENT - Day 1:
Oracle BI Publisher Architecture
- Describe the components of Oracle BI Publisher
- Describe the architecture of Oracle BI Publisher
- Describe the technology of Oracle BI Publisher
Introduction to the Standards
- Describe the X Standards
- Understand XML, XML Schema, DTDs, and XSL
Oracle BI Publisher Enterprise Administration
- Define security issues
- Understand how to administer security
RTF Templates
- Explain the capabilities of RTF templates
- Describe the methods for RTF template creation
- Create an RTF template
Advanced RTF Template Techniques
- Describe advanced RTF template capabilities
- Complete a lab using some of those advanced capabilities
PDF Templates
- Describe the capabilities of PDF templates
- Describe other template formats
Building a Data Template
- Understand data templates
- Create and associate a data template
Translations
- Describe the options for translating reports (e.g Discoverer to BI Publisher or Oracle Reports to BI Publisher)
- Perform the maintenance processes for translations
CONTENT - Day 2:
Integration with Oracle BI Enterprise Edition
- Publish a BI Publisher report created from an Answers request
- Publish a BI Publisher report created from a BI Server repository
The eBusiness Suite Development Process
- Understand the eBusiness Suite development process
- Create and deploy an XML Publisher report
Using Oracle BI Publisher Enterprise
- Access the Oracle BI Publisher Enterprise Server
- View, schedule, and create reports
- Create a list of values
- Create a hierarchical column
Modifying an Existing Report
- Access the Oracle BI Publisher Enterprise Server
- View, schedule, and create reports
Miscellaneous Report Formats
- Excel and the Online Analyzer
- Reports with Multiple Datasources
- Federated Report ???
- Reports with multiple datasources