BI Publisher

 Click here

Course Overview

Students in this course will gain a firm foundation in the BI Publisher technology. A 2-day course, BI Publisher can be taught with 2 focus areas. The first focus area is the overlap with Oracle Business Intelligence Suite (OBI), and the second focus area is the overlap with Oracle Applications (Apps). In Oracle Applications implementations, BI Publisher is commonly referred to as XML Publisher. Both courses will expose students to the basic mechanics of building a full production quality BI Publisher report. Both will discuss the current Oracle reporting paradigm and the technical shift in direction from Oracle Report to Bi Publisher. Where the courses differ is in their respective reporting architectures. While Oracle BI Publisher can integrate and function as a integrated component of Oracle Business Intelligence, or even provide a reporting medium as a standalone, BI Publisher is also tightly integrated with the reporting capabilities of Oracle Applications. Even executives and managers can gain insight into various ways to leverage their BI Publisher investment with existing Oracle Reports and data feeds.

Course Goals

• Joint Course Goals
  • Gain a general understanding of Oracle BI Publisher components and structure.
  • Obtain foundational hands-on experience in Oracle BI Publisher through rigorous lab exercises.
  • Gain an understanding of how to create sophisticated, pixel-perfect reporting templates.
  • Explain the syntax and usage of XML in reports.
• Oracle Applications focused BI Publisher course
  • Learn the architecture involved in Oracle Applications and BI Publisher.
  • Understand how to setup, register, and execute BI Publisher reports in Oracle Apps.
  • Discover the various ways to access source data.
• Oracle Business Intelligence focused BI Publisher course
  • Learn the architecture involved between Oracle Business Intelligence Suite and BI Publisher.
  • Gain a foundation on how the 2 technologies work together seamlessly.
  • Explore the Administration interfaces to setup and ultimately publish a full report.
  • Discover the various ways to access source data.

Prerequisites

• Previous experience with the Oracle Database is required.
• Previous experience with basic SQL syntax is required.
• Previous experience with Oracle PL/SQL is not required, but very helpful.

Who Should Attend?

• Application Developers
• PL/SQL Developers
• Oracle Reports Developers
• Technical Consultants
• Business intelligence Developers
• Bi and Reporting Managers

Course Materials

• Oracle Business Intelligence Publisher and Reporting course materials

Duration

• Two (2) days, with an optional focus on either Business Intelligence Suite or Oracle Applications.

Course Outline

• Introduction to Oracle Reporting
  • Overview of All of Oracle's Reporting Capabilities.
• Oracle Reports Overview
• BI Publisher Overview
• Comparing BI Publisher and Oracle Reports
  • Comparison of features, strengths, and weaknesses.
• XML Concepts
  • Understanding XML, structure, content, and uses.
  • Understanding some advanced concepts such as XSL, XML Schemas, and XSD.
• BI Publisher Desktop tool and BI Publisher Templates.
  • Overview of the Templating Tool and process.
  • The Template Viewer Tool.
• Extending your Templates and producing BI Publisher Reports
  • Conditional embedded logic, XSL, and the API available.
  • Date, currency, and text formatting.
  • Working with Headers and Footers.
  • Advanced programmatic techniques such as looping, formatting, and XSL coding.

   

  Oracle Applications Specific Topics:

• Integration within E-Business Suite
  • Localizations, Language Translations, and XLIFF.
  • Barcoding Techniques.
  • Registering a report within the XML Publisher Administration interface.
  • Learning when to use Oracle Reports vs when to use BI Publisher.
• Full Lifecycle walkthrough
  • Hands-on walkthrough from concept to completion of a production ready report in Oracle Applications.

   

  Oracle Business Intelligence Specific Topics:

• Integration within Business Intelligence Suite
  • Registering a report within the BI Publisher Administration interface.
  • Exploring the BI Publisher interfaces.
  • Interacting with data sources.
  • Working with various charts and graph styles.
  • Integration with various aspects of the Oracle Business Intelligence Suite.
• Full Lifecycle walkthrough
  • Hands-on walkthrough from concept to completion of a production ready report in
  • Oracle Business intelligence Suite.